Viewing 15 posts - 256 through 270 (of 294 total)
When you restored did you leave in a NORECOVEY or STANBY state?
Try: Restore database DBName with Recovery
November 12, 2007 at 10:55 am
The results of sp_helprevlogin applied to the new server should work if the domain is the same, if there were problems then you will get error messages indicating which logins...
November 12, 2007 at 8:56 am
One thing to try, within SQL Server Agent move to Alert System and Ensure that the Enable Mail Profile is checked.
November 5, 2007 at 9:33 am
The 3 tables could be joined in a view, if each of the tables was placed in a different filegroup you would have your partitioned view.
You may wish to extend...
October 15, 2007 at 10:49 am
The same but not the same, SQL Server doesn't recognise them as the same.
October 11, 2007 at 7:02 am
I most often come across the issue when the server install gets completed and the guys don't alter the regional settings to UK, then when SQL Server gets installed it...
October 11, 2007 at 6:24 am
"Most DBAs don't ever deal with multiple languages or different collation and sort order settings in SQL Server"
The majority of UK DBA's will have come across collation issues, its...
October 11, 2007 at 3:40 am
If I alter the server name I will use sp_dropserver sp_addserver, however the clients are all connecting via an application which uses an .ini file that contains both connection details...
October 10, 2007 at 4:39 am
They seem to have a .ini file with the connection string in it, the server name in this file seems to be the new server name.
October 9, 2007 at 2:26 pm
I'm fine with fixing this with sp_dropserver sp_addserver what I'm not a hundred percent sure of is whether the 100's of users connected will have any problems if I fix...
October 9, 2007 at 12:55 pm
If you detach and reattach from 7 to 2000, remember to reindex also probably need to update statistics as well.
October 1, 2007 at 7:36 am
The user would need probably need execute permissions on xp_fixeddrives.
April 17, 2007 at 1:30 pm
In Enterprise Manager when you view the linked server can you see the tables? Probably not. Try the following:-
Read books online look for sp_addlinkedserver, sp_dropserver and sp_addlinkedsrvlogin.
Drop what you've already...
March 14, 2007 at 4:47 pm
If you just drag the field over from the dataset window it will poplulate with the First syntax ie:
=First(Fields!Started.Value, "ServerNameUptime")
March 12, 2007 at 9:54 am
Viewing 15 posts - 256 through 270 (of 294 total)