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...

i think this can be handled two ways;

your instance is listing for SQL Server connections on a different port than the default instance of 1433;

you can either change the listing...

someone who posts here has a tagline that says:

XML is like violence...if it doesn't solve your problem your not using enough of it.

dang i knew that too Remi; just didn't include it in my attempt for a sample; i get to do mostly .net winforms and pages now, so my vb is...