Viewing 15 posts - 33,376 through 33,390 (of 49,552 total)
Suspect means that the database may be transactionally or structurally inconsistent. This is the result of either a rollback failing (typically because it encounters a corrupt page) or the restart-recovery...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 22, 2010 at 9:34 am
It had better be a very good reason. Messing with the system tables, especially on SQL 2005 where they are not documented and not straightforward, is a quick way to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 22, 2010 at 9:25 am
You can't. That message is added when someone does a direct update to the system tables (which requires more than just sp_configure 'allow updates',1). It's there as a warning that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 22, 2010 at 7:53 am
Why? What's wrong with the standard code? What is it not doing that it should?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 22, 2010 at 7:47 am
Did you bother to read the links that bitbucket provided? If not, please do so. If you still have questions after reading them, come back and ask.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 22, 2010 at 7:20 am
Even if such a thing is possible, by doing so you will completely lose all support from Microsoft. If you hack a system like that and then call customer support...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 22, 2010 at 6:57 am
chandrasekaran.ganapathy (3/22/2010)
Can I declare a temp table outside the procedure and call it inside the procedure?In procedure we can create a temp table?
Yes and yes
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 22, 2010 at 6:29 am
A temp table is dropped when the connection that created it is closed or when the procedure that it was created in ends.
You can't create a temp table in a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 22, 2010 at 6:18 am
That's complete garbage. It's AWE that's not required on 64 bit operating systems with 64 bit SQL.
If you look at the annotations (Click the 'annotations link, top-right of the page),...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 21, 2010 at 2:02 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic886960-150-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 20, 2010 at 3:11 pm
Just too easy to have something else in SSMS grab the only connection. Specially if there's 3rd party add-ins in SSMS (which I have). SQLCMD I know there's only one...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 20, 2010 at 11:06 am
I prefer to have SSMS set to open an empty environment. No object explorer connections, no query window connections.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 20, 2010 at 10:33 am
Lynn Pettis (3/20/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 20, 2010 at 10:27 am
malleswarareddy_m (3/20/2010)
using sqlcmd utility it worked fine.but using ssms it not worked.
Possibly because Object Explorer took the only allowed connection. It's one of the reasons I prefer to use SQLCMD...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 20, 2010 at 9:26 am
Master cannot be set into single user mode. Why are you trying?
rebuildm is a SQL 2000 command for rebuilding the master database. In SQL 2005 the setup command is used...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 20, 2010 at 4:00 am
Viewing 15 posts - 33,376 through 33,390 (of 49,552 total)