At another job I did this using VB and SQL-DMO.  DMO contains objects and methods that can generate scripts.  Check it out in the books online.  I looped thru all...

I usually tell my clients not to run anti-virus on SQL servers, to me it's just a waste of resources on that machine...I don't see the need to scan folders,...

Check the permissions on the folder you are saving to; we do this all the time, and permissions need to be correct for the package owner ( If scheduled, the...

Check out http://www.sqldts.com.  This web site shows you how to use the DTS object model to execute packages (using Visual Basic).  We use the methods shown here to kick...

I find it hard to do the insert with a join, since the records don't exist in table a.  I do it this way:

insert into tablea select mycolumnlist from tableb...

First glance looks like your IF statement; @@Error is not boolean.  Change it to: IF @@Error <> 0...

I use this method, sometimes passing back the actual error number, sometimes a...

Nope.  In fact, making your SQL box also a PDC or BDC isn't a good idea...too much network traffic...

I've done this before...Like This:

1.  Shut down the SQL Services MSSQLSERVER and SQL Server Agent on both boxes.

2.  COPY the database files (.mdf .ndf, .ldf) from old server to new...

I have never found an easy way to do this, but have had this situation many times...I usually set up a script like this for each table:

insert into test.table1 (test column...

I'd use the CONVERT function on time_col to pick off the date, then concatenate the time to it...like this:

-- @mytime is a variable that contains the formatted time, like 08:00. ...

Jack is correct...or you can use the PATINDEX function if you need to use a wildcard in the search argument.

Steve

I have noticed similar behavior from the log, and noticed that when the log reaches 70 percent full it will automatically shrink when I am inserting.  I discovered that, even...

I believe that this is by design.  When a column contains null, what is really means is that it contains no value.  Therefore, you can't use any comparison operators (including...