Viewing 15 posts - 1 through 15 (of 369 total)
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...
October 6, 2011 at 11:56 am
Thanks for the help! I thought maybe you had to double up all backslashes but just the last one was the key.
February 23, 2011 at 12:38 pm
The Sql Server Express cannot be a distributor. It can only be a subscriber with a push subscription to it.
At least that is my understanding from the Microsoft documentation...
January 11, 2011 at 1:25 pm
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.
January 11, 2011 at 1:14 pm
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...
November 9, 2010 at 7:28 am
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...
October 29, 2010 at 8:53 am
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...
October 22, 2010 at 9:02 am
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.
October 11, 2010 at 1:06 pm
Not sure it would help, but you can do snapshot replication without primary keys which could be run nightly.
October 5, 2010 at 12:03 pm
We were running under a domain account and it still happened.
September 17, 2010 at 6:38 am
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...
September 16, 2010 at 2:09 pm
September 16, 2010 at 2:08 pm
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...
September 10, 2010 at 10:57 am
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...
September 9, 2010 at 7:53 am
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...
September 7, 2010 at 11:51 am