well, the syntax for sp_addlinkedserver is here or in BOL:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_adda_8gqa.asp

EXEC    sp_addlinkedserver    @server='S1_instance1', @srvproduct='',          ...

remember a datetime is actually stored as a decimal type number, and the format is arbitrary....its stored as a number like 12345.67, where the 12345 is whole days, and the...

go ahead and download the service pack from this page;

 http://www.microsoft.com/sql/downloads/2000/sp4.mspx

note in the middle of the article it explicitly says that it is for the MSDE, and that you need...

if you are going to be connecting dynamically, i think it is better to use an application to determine and connect to the server, and then execute whatever code you...

could it be the file system operations of the FTP and UNZIP operations are not truely completed when it goes to the next step of the TSQL? The OS may...

select CONVERT ( datetime,getdate(),102 ) might do what you want:

2005-05-27 11:55:35.467

yet another... appropriate for a developer but not production...this sets autoclose as well as the recovery,so that enterprise manager opens quickly, because the databases are not closed.

declare

@isql varchar(2000),

@dbname varchar(64)

declare c1...

someone posted a similar issue where orders off of their web site were being lost....a table was scanned by a process looking for orders every five minutes or so, and...

i think it is comman instead of semi colon:

xxx.xxx.xxx.xxx,1433

so a connection string might look like any of these:

cnObj.ConnectionString= "Provider=SQLOLEDB;Server=65.34.234.179;database=GHBA;uid=tester;pwd=password"

cnObj.ConnectionString= "Provider=SQLOLEDB;Server=65.34.234.179,1433;database=GHBA;uid=tester;pwd=password"

cnObj.ConnectionString= "Provider=SQLOLEDB;Server=65.34.234.179,1207;database=GHBA;uid=tester;pwd=password"

try this...the syntax is simply sp_kill dbname

--enhanced 02/04/2005 to also list hostname  

CREATE PROCEDURE sp_Kill 

 @DBNAME VARCHAR(30) 

--Stored procedure to Delete SQL Process 

AS 

BEGIN 

SET NOCOUNT ON 

 DECLARE...

it's all about scheduling and automating a task, vs user intervention. once set up, a scheduled script never needs to be handled again, and the DBA is freed up to...

LanMan we were refering to using command line functionality to script a zip file; as far as i know, WINRAR is a gui interface only. WinRAR is a great utility,...

Franks right; splitting an entry on vbCrLf is not all that easy; you might need to modify something like the SPLIT function found here on sqlservercentral.com:

http://www.sqlservercentral.com/scripts/contributions/835.asp

the split function works great...

pkzip25.exe handles longfilenames; you simply wrap them in double quotes;

pkzip25.exe -a "D:\MSSQL\BACKUPS\DatabaseName-Thursday.bak" "\\SomeServer\SharedFolder\DatabaseName-Thursday.zip"

could it be that when the procedure is called, @NumId is null, and produces unpredicatable results, like deleting everything?just a thought.