|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
 |
How can I drop a table on a Linked Server ?
|
| Total Hit (2705) |
Assume that you have to execute the command DROP TABLE tableName on a linked server. The typical syntax that someone will try is:
DROP TABLE serverName.master.dbo.TableName
This for some reason fails ... If you were wondering why this happens then the answer is simple. The context of the user
....Read More |
Rating
 |
|
|
|
|
|
|
|
|
|
|
|
|
|
 |
Sample Chapter from Visual Basic .NET Threading Handbook
|
| Total Hit (3152) |
This book will cover how .NET applications are executed, the life cycle of a thread in .NET, how the .NET Framework uses threads, how threads work in an event-driven environment, how we can avoid race conditions and deadlocks, how the activity of multiple threads can be synchronized, and how to debu
....Read More |
| Rating
|
|
|
|
|
|
|
|
Import all files in a directory using DTS (Multi Pkg)
|
| Total Hit (2298) |
This example shows how you can use two DTS packages to control the import of all files in a given directory. For this, it is assumed that all files have the same format, and that all files are imported into the same table.
|
| Rating
|
|
|
|