Thanks for that piece of information. I haven't upgrade to VS 2010 yet but my co-worker has and he said it was no problem as long as you use...

Thanks for the help! I thought maybe you had to double up all backslashes but just the last one was the key.

Steve

The Sql Server Express cannot be a distributor. It can only be a subscriber with a push subscription to it.

--Edited--

At least that is my understanding from the Microsoft documentation...

Be sure to do a push subscription to the Sql Server Express. The push subscription will run from the ss agent on your publisher / distributor.

Steve

I too chose None of the Above (interpreting that it meant ("it depends") because system databases are excluded from Database Snapshots. If you follow the logic that all Simple...

I hate to admit it, but I got distracted by the fact that the select contained "@a A". Thinking that this was too easy of a question made me...

As previously mentioned, you can assign a variable in a script task which is a Visual C++ or Visual Basic program.

You assign the variable to the Script Task ReadWriteVariables property...

It came become not very straight forward when you throw in the case of muti-part last names like Mc Donald or O Brien and Suffixes Like Sr, Jr or III.

Steve

Not sure it would help, but you can do snapshot replication without primary keys which could be run nightly.

Steve

We were running under a domain account and it still happened.

Steve

One thing I found out is that taking the group NT AUTHORITY\SYSTEM out of the SysAdmin group made it so I could not start a service (Agent or otherwise) after...

One thing I found out is that taking the group NT AUTHORITY\SYSTEM out of the SysAdmin group made it so I could not start a service (Agent or otherwise) after...

From what I understand, the script task in SS 2005 is VbScript and in 2008 it is full fledged VB. I'm not sure of the ramifications of that but...

Backing up the transaction log does not automatically shrink it, it frees up the space used in the log so it can be reused. If you use FULL recovery...

Admission Number must not be a true primary key if you can have multiple instance of it. Is there another column combined with Admission Number that provides the complete...