Same way as you're already doing for granting access...

IF EXISTS (SELECT 1 FROM dbo.syslogins WHERE name = 'MyLogin')

EXEC sp_addlogin...

This tool works very well for transferring DTS packages from one server to another.

http://www.sqldts.com/default.aspx?242"

The site also has many helpful suggestions for working with multiple DTS packages.

One way to cut down is to delete in batches. It doesn't eliminate logging, but it will down the log entries. Also, the deletes will run faster if...

Unfortunately, one of the big let downs of SQL Express is that there is no agent.

For a more complete list of differences check here:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

This forum is for SSC.com site suggestions...

Please post your question in the appropriate forum.

Perhaps this one:

http://www.sqlservercentral.com/forums/messages.aspx?forumid=20

Not only does it help keep the site clean and stand a far better...

So, you have a table with at least one other column aside from the column that has all of these integers, right?  If so, PLEASE at least do one of the...

First, MTL space by default is 384MB.

512KB * [max number of threads] + 256MB.

Aside from using the -g switch, you can also raise this amount by raising the max number...

This article lays out the details.

http://msdn.microsoft.com/library/?url=/library/en-us/architec/8_ar_sa2_0ciq.asp?frame=true

Also, I made a correction to my previous post, as MSDE 1.0 is limited to 5 connections, not MSDE 2000.

Basically, there's no hard limit,...

This should work:

SELECT ItemCode

FROM tblMaster

WHERE ItemCode NOT IN (SELECT ItemCode FROM tblTrans)

If you're receiving that error in the event log, then it means that threads are having to wait. It's not the end of the world, but it does mean...

Just a thought...

Since this is a CHAR datatype, make sure you are not trying to spaces...

An easy oversite on the app end is to not TRIM trailing spaces before letting...

By default, SQL 2005 doesn't upgrade the databases themselves (or it didn't the last time I used it) due to possible compatibility issues that might exists in some databases (it's...

This is most likely due to paging and a long disk queue.

If you're running on local disks, seek a SAN, or at least more disks.

The easiest way to tell is...

The lack of response might be because this post is in the wrong forum.

It should be moved here:

http://www.sqlservercentral.com/forums/messages.aspx?forumid=148

To the best of my knowlegde with regards to MS, even if you buy a support ticket with a credit card, they will work 24-7 to resolve a production issue. ...