Viewing 15 posts - 36,901 through 36,915 (of 49,552 total)
Can't remember sql 2000 very well. The only way you're going to fix this is by removing that -m.
Go to Services (Control panel-administrative tools-Services), find the SQL Server service and...
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
August 21, 2009 at 8:02 am
Also asked here: http://www.sqlservercentral.com/Forums/Topic774795-146-1.aspx
No more replies to this thread please.
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
August 21, 2009 at 7:59 am
ta.bu.shi.da.yu (8/21/2009)
GilaMonster (8/21/2009)
Anyone keen on several pages of cursor-ridden SQL, a badly explained problem, two threads and no data?http://www.sqlservercentral.com/Forums/Topic774014-146-1.aspx
http://www.sqlservercentral.com/Forums/Topic774898-146-1.aspx
Oooo... sounds tempting. sadly, I think I'll pass.
Would you mind please moving...
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
August 21, 2009 at 7:54 am
Anyone keen on several pages of cursor-ridden SQL, a badly explained problem, two threads and no data?
http://www.sqlservercentral.com/Forums/Topic774014-146-1.aspx
http://www.sqlservercentral.com/Forums/Topic774898-146-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
August 21, 2009 at 7:25 am
My home file server (domain controller, sharepoint server) is running Server 2003 and has 4 drives in a RAID 5 config. Served me very well earlier this year when 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
August 21, 2009 at 7:22 am
Chris Fitzgerald (8/21/2009)
However, you usually use this option if your database structure changes frequently.
Not structure. If a table's design changes, all procs dependent on it are automatically marked for recompile....
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
August 21, 2009 at 7:20 am
Edit: Nevermind, the post above (and the one below) is spam.
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
August 21, 2009 at 7:18 am
panwar.jt (8/21/2009)
but problem is still there
One problem, one thread. Having multiple threads for the same problem just wastes people's time as they answer stuff already answered.
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
August 21, 2009 at 7:15 am
Please post table definitions, sample data and desired output, also the full definition of the proc and the parameters that you're calling it with. Read this to see the best...
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
August 21, 2009 at 6:18 am
This doen't look like it has anything to do with the system tables, and it's also asked here: http://www.sqlservercentral.com/Forums/Topic774014-146-1.aspx
No more replies here unless they're related to the system tables please.
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
August 21, 2009 at 6:16 am
Silverfox (8/21/2009)
Noooo, that means I need to fill in another registration form. Your a very bad person, Stop trying to get me to network 😛
That's nothing to do with networking...
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
August 21, 2009 at 6:14 am
Silverfox (8/21/2009)
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
August 21, 2009 at 5:30 am
suleman_3014 (8/21/2009)
These tables can now only be accessed via Direct Administrator Connection (or DAC).
Using the DAC doesn't allow you to modify the system tables. Even on SQL 2000 (iirc)...
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
August 21, 2009 at 5:28 am
You can't change the collation of system tables. In fact, you can't change system tables.
I see you're changing collation, what specific problems/concerns do you have that you want/need to change...
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
August 21, 2009 at 5:27 am
panwar.jt (8/21/2009)
Look below problemhttp://www.sqlservercentral.com/Forums/Topic774014-146-1.aspx
I don't see anything to do with system tables in that thread.
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
August 21, 2009 at 5:13 am
Viewing 15 posts - 36,901 through 36,915 (of 49,552 total)