I am amazed with how many people here have associated a clustered index with a primary key... That's the way the gui does it by default, but by no...

I agree..the answer is not necessarily right. Changing the Clusterd index does not necessarily mean changing the primary key. But how often is the Primary key selected from?

There...

I enjoyed Greg's article and am hoping that my article on Fill Factor's is one of the two for this week. Greg brings up a good point with...

I don't have an answer and am currently troubleshooting potential ODBC issues. I have enabled logging on the DSN on the client, and have also enabled the performance counters...

Is the MSTASK.exe from the Task Scheduler? I believe it is, but not 100%. It looks like it is erroring, but also prompting (this is why it is...

Try executing a DBCC CHECKDB on the database. This grabs some resources. From the looks of it you may be able to execute a DBCC CHECKFILEGROUP <syntax?>

Could be a couple of things, but the first thing that jumps to mind is that you may be using the name of the Clustered server for your instance name...

For...

Since when is a DTS package considered DDL? This is new to me!!

If your DBCC checks would fail then chances are your not going to be able to restore the database..at least not cleanly. This is one of the reasons it...

JM,

I snickered on this one 🙂 Yes, I have the 15-20 Servers and am the only DBA, and I also do some development and report writing. I...

I have something in place similar to Renee's solution, accept I like hers better. I put a function in every database and granted execute to public on the...

Maybe I am missing something here. The query only states the filegroup, not the file in the file group.

I spent some time a year ago looking for the file...

Great stuff everyone. I too like the Delphi environment (and love Borland's C++ with VCL{I think Microsoft makes most of their Windows apps with the VCL, but may...

As a general rule around here, I have all of the stored procedures scripted with the GRANT EXECUTE permissions at the bottom of the script.

But, there are plenty of ways...

Mucho thanks...Seems I am on the right track and it's nice to know others have been through this before (even if it was an emergency)

Jeff