Viewing 15 posts - 1,486 through 1,500 (of 6,216 total)
Can also check sysprocesses to see if the diskio/cpu are increasing for the restore spid.
Andy
October 13, 2003 at 4:08 am
Transfer how? Where would you put it in Exchange?
Andy
October 13, 2003 at 4:06 am
Are you using the same login for both? EM is slower than QA, so if it's a slow connection you may just have to wait on it.
Andy
October 13, 2003 at 4:05 am
Steve worked on it last night - apparently not long enough!
Andy
October 9, 2003 at 7:50 am
Saw your note yesterday at home, our Brian is supposed to be checking!
Andy
October 8, 2003 at 1:12 pm
Yes and yes. Selecting a view just sends over the definition of the view, not the data the view represents. Changes to the view after the initial snapshot are not...
October 8, 2003 at 9:06 am
In terms of a SQL restore, a SAN is no different than any other drive system. If you have SQL2K there is a switch you can add that will kick...
October 8, 2003 at 8:28 am
Do you have any user assigned to the sysadmin role? Maybe someone else on the team or you network admin? Worst case you can run RebuildM to generate new master/msdb,...
October 8, 2003 at 5:41 am
October 8, 2003 at 3:44 am
Nope. You can redirect output from osql.exe to a file fairly easily. In SQL you'd typically use DTS to execute the query and export it to disk in whatever format...
October 8, 2003 at 3:44 am
Not that I know of. Typically on the app side you avoid this by changing the connection string or executing a use db on the open connection. One way might...
October 7, 2003 at 11:46 am
You're missing records inserted on the publisher? Is the distribution agent running?
Andy
October 7, 2003 at 11:43 am
Turn on logging for the distrib agent. Use -outputverboselevel 3 -output c:\repl.txt. Might have to double check the syntax, but that is close.
Andy
October 7, 2003 at 4:21 am
Usually because they don't have a primary key - a requirement for transactional. Note that selecting stored procedures means that they get pushed over with the initial snapshot, but subsequent...
October 7, 2003 at 4:20 am
Viewing 15 posts - 1,486 through 1,500 (of 6,216 total)