Viewing 15 posts - 1,771 through 1,785 (of 5,356 total)
Now, when you search the Google archives you amazingly often cross the name Celko ![]()
For example, http://groups.google.de/groups?hl=de&lr=&selm=OnfVNuP3%24GA.246%40cppssbbsa04
or
This is for C#:
http://groups.google.de/groups?hl=de&lr=&th=450bf279be9dbda&rnum=1
I...
November 18, 2004 at 7:35 am
This is probably not more than guessing, so bear with me
- you are in the right db?
- the triggers exists?
- they are not recreated by any other operation?
Hey, I'm running...
November 18, 2004 at 6:54 am
See, if this helps:
http://www.terraserver.microsoft.com/
http://www.microsoft.com/technet/prodtechnol/sql/2000/plan/ssmsam.mspx
http://www.microsoft.com/sql/techinfo/administration/2000/scalability.asp
http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.asp
November 18, 2004 at 6:50 am
...but you are logged in with appropriate privileges, right?
November 18, 2004 at 5:54 am
So, as this sounds strange and as a kind of last resort, did you also try this from within Enterprise Manager? "Usually" this operations should only be a matter of...
November 18, 2004 at 5:51 am
And what was the error message?
How did you try to run this?
November 18, 2004 at 5:39 am
Are you trying to drop it via DROP TRIGGER? Maybe you should post your statement.
November 18, 2004 at 5:25 am
You're missing the fact, that when you move a db that db includes all of its objects. That is procedures, views, UDFs...
Here are some useful informations
http://support.microsoft.com/default.aspx?scid=kb;EN-US;314546
http://support.microsoft.com/default.aspx?scid=kb;EN-US;240867
http://support.microsoft.com/default.aspx?scid=kb;EN-US;274188
November 18, 2004 at 5:20 am
...you asked for it, Jeff ![]()
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql7/html/sqlquerproc.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa_4azp.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/statquery.asp
http://support.microsoft.com/default.aspx?scid=kb;EN-US;836136
And, of course, you can read about it in "Inside SQL Server 2000"
November 18, 2004 at 4:22 am
Okay, I'll make a start here ![]()
There are some explanations in BOL. Look for "Rebuild master". In addition I have a link to the...
November 18, 2004 at 1:48 am
ONe way could be to pipe the result of
EXEC master.dbo.xp_cmdshell 'osql -L'
to a table and analyze it thereafter.
AFAIK, this will work as long as the servers are not hidden,...
November 18, 2004 at 1:44 am
From my understanding so far, in most configurations I don't see any advantage in having multiple filegroups. I'd rather have one filegroup spread over as many physical drives as possible. Multiple...
November 18, 2004 at 1:32 am
...and I forgot, I haven't verfiy this myself, but I was told that the difference in execution plans is getting bigger with SQL Server 2005.
![]()