What is actually your question? You would like to operate (execute and stuff) remotely by using only the command line?

Take a look at http://www.sysinternals.com/Utilities/PsExec.html by our old friends at SysInternals!

But...

Hello!

What is actually your question? Is it why the StartDate field is part of the PK?

What do you mean by a 'go between' table?

Regards,

Hanslindgren

No problem, most important is that you managed to get help here

And that you provided feedback that it actually did help. Too...

I would say BOL is the best place

Beware that this might be dangerous if you only want to change the part after the @ sign and before the first .

The above could potentially change also the...

And why not take a look at the Webcast produced by the aforementioned columnist?

http://www.sqlservercentral.com/articles/articlelink.asp?articleid=2563

Which is actually featured in todays newsletter

Only way I know of is if someone actively reseeds it (like you did to correct it)...

If you are using the same data for test you will probably notice very little to no performance gain through the use of VARCHAR(50) instead of VARCHAR(8000). Due to the...

I feel like I must break in here and elaborate on what Colin probably meant and correct Chris missconception of data storage in SQL Server:

If the VARCHAR is not VARCHAR(MAX)...

That sounds like a job for SQL Server Reporting Service!

And yes, you can do exactly that.

Happy (ab)use of it!

Hanslindgren

Use a T-Log explorer tool, that is IF you use Full Recovery.

And maybe now should be the time to restrict permissions?

Hanslindgren

Well, the BEGIN TRAN and COMMIT TRAN in ADO.NET has to do additional round trips to the server.

Additionally, doing it in ADO unfortunately makes it too easy to keep your...

If you are filling your .XLS with the help of Import External Data, you can configure your 'External Data Range Properties' to refresh every X minutes, everytime the .XLS is...

Hello,

To replace empty values with NULL use the function NULLIF( myColumn , '' ).

Example:

CREATE TABLE #myTable ( myColumn VARCHAR(50) NULL )

INSERT INTO #myTable (myColumn) VALUES ('Test')

INSERT INTO #myTable (myColumn) VALUES...

Yes. DTS is overkill. You only want to execute a few simple T-SQL statements, you have no need of anything you cannot conveniently find in T-SQL.

This can be sceduled as...