Viewing 15 posts - 7,336 through 7,350 (of 7,368 total)
take a look at : Microsoft Knowledge Base Article - 814064 BUG: SQLBrowseConnect May Cause an Access Violation in the Client Application.
February 10, 2003 at 12:31 am
try this :
Setup.exe /upgradesp SQLRUN INSTANCENAME=MSSQLSERVER SECURITYMODE=Sql UPGRADEUSER=sa UPGRADEPWD=<sa pwd>
February 5, 2003 at 12:27 am
what if that original node is gone ?
February 5, 2003 at 12:14 am
Great article. Especialy the conclusion, wich IMO should be put en a red colour and an extra bold font.
January 27, 2003 at 3:26 am
remember you can only shrink your logfile at "the end". If that last section is in use, you cannot shrink. The "forced" shrinks only fillup the last section during a...
January 16, 2003 at 12:09 am
Use dbcc traceon(1204; 3605; -1) to have sqlserver log deadlock-situations in the sqlserver-logs. This gives good info.
January 3, 2003 at 12:04 am
Where the spids in as rollback-state ? Then you cannot kill them. I've noticed this in relation with some non-IT-developed access-applications. After these applications where banned to use the production...
January 2, 2003 at 11:59 pm
Maybe I'm looking at a small scale, but any chance DTS could help out ?
December 9, 2002 at 12:37 am
When scripting remember to script the user/role-autorities as well !
As for the warm feeling : Enjoy it as much as possible!
December 9, 2002 at 12:30 am
what are (index and )datapagestatistics stating ? (imho Shrink is only freeing empty pages)
December 9, 2002 at 12:15 am
what are (index and )datapagestatistics stating ? (imho Shrink is only freeing empty pages)
December 9, 2002 at 12:15 am
The only way to be sure about the sort order of the resultset is to put an ORDER BY clause in your query. Group by might give a correct result,...
November 29, 2002 at 2:11 am
Sorry I wasn't that specific. Antras686 completed the missing link in this case 😉
November 28, 2002 at 12:01 am
if you're using EM , just design the view and add a space somewhere and push the apply-button.
November 27, 2002 at 12:33 am
search for killpwd.exe
from MS :
Microsoft has created the KillPwd.exe command utility to search Microsoft® SQL Server™
setup files for the System administrator (sa) login password. If the KillPwd.exe command
utility...
November 25, 2002 at 5:32 am
Viewing 15 posts - 7,336 through 7,350 (of 7,368 total)