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.

I don't think you can connect to an ip address, by instance name, if you are not on the same subnet. if your instance is on a public IP, you...

the text for an sp , if not encrypted, can be searched in syscomments.

select sysobjects.name from sysobjects

inner join syscomments on sysobjects.id = syscomments.id

where sysobjects.xtype='P'

and  text like '%view%'

the ordsys is an extension for image manipulation from within the oracle environment;

the nearest equivilent would be creating a dll in .NET for example, which uses the functions in System.Drawing, and...