Viewing 15 posts - 91 through 105 (of 451 total)
Changing sa or windows account password has no impact on DB/job ownership.
It does not matter the DB is under sa or windows account. You may have to change the...
July 30, 2008 at 8:41 pm
Need to repopulate full-text catalogs
BOL: How to: Upgrade to SQL Server 2005 (Setup)
More details: SQL Server 2005 Upgrade Technical Reference Guide
Pay attention to MSSearch service account in SQL2005
July 22, 2008 at 6:28 pm
Thank you all for your input. I have more options to try now.
July 22, 2008 at 7:54 am
Jeff Moden (7/18/2008)
Vivien Xing (7/18/2008)
isql/w is something like this:http://www.imranweb.com/freesoft/
"For more information on Enhanced ISQL/w, read this document. "
isql/w != isqlw
Aghhh... My apologies... you are correct. Could even see the...
July 18, 2008 at 8:10 pm
isql/w is something like this:
http://www.imranweb.com/freesoft/
"For more information on Enhanced ISQL/w, read this document. "
isql/w != isqlw
July 18, 2008 at 11:02 am
isql/w is a very simple/basic GUI. It is more like a text editor as I remember. It is not rich like query analyzer. The link below may...
July 17, 2008 at 9:02 pm
I mean the explanation does not match the question & answer.
July 17, 2008 at 8:37 pm
Is the answer right? or is this the answer for this question?
"Resource management is limited to the SQL Server Database Engine. Resource Governor can not be used for Analysis Services,...
July 17, 2008 at 8:35 pm
Is it another good reason to move to Vancouver?
Microsoft Expanding Canadian Operations in Greater Vancouver Area
New software development center to be opened in fall 2007.
http://www.microsoft.com/presspass/press/2007/jul07/07-05MSExpandVancouverPR.mspx
July 17, 2008 at 6:48 pm
Microsoft has a whitepaper mentioned about capacity planning and deletion feature.
There third party applications available for archiving with a big cost $$.
July 14, 2008 at 9:09 pm
The link "SQL Server Management Studio Keyboard Shortcuts" is very helpful.
July 14, 2008 at 8:24 pm
Click "Members" link in the top right corner, and sort by no of posts (actually by points) to see all the members and their scores.
July 14, 2008 at 5:18 pm
Thank you Ken. That is a good starting point.
July 11, 2008 at 8:19 am
rbarryyoung (7/10/2008)
Vivien Xing (7/10/2008)
rbarryyoung (7/8/2008)
re-corrected version (sorry):still errors ?
You would have to tell me what the errors were since it works fine for me. I have tried it on...
July 10, 2008 at 5:11 pm
rbarryyoung (7/8/2008)
Alter Proc spLogin_OwnedObjects ( @login as SYSNAME ) As
/*
Display all objects in all DBs owned by the Login.
2008-07-06 RBarryYoung Created.
Test:
spLogin_OwnedObjects 'sa'
*/
declare @sql varchar(MAX), @DB_Objects varchar(512)
Select @DB_Objects =...
July 10, 2008 at 2:55 pm
Viewing 15 posts - 91 through 105 (of 451 total)