Seeing as this is a Red-Gate sponsored forum and in the light of your predicament would there be a case to investigate the use and purchase of SQL alert for...

Just my 10 Cents worth

4730167 seconds is about 54 Days, and even in Microsoft time that's a bit odd that a process would take that long. And I...

Please correct me if this is incorrect but, there are two types of index Maintenenace

1. rebuilding an Index and;

2. Re-organizing an Index

And the difference is signifigant....

There really is only one answer to this and that is ALWAYS. And not just a software partition but a separate device altogether. Even if it's a small system...

Woot. First In ....

I have to say Blue tooth. No cables, No running over your mouse tail and no Leads to my headphones to get in...

BTW I have actually rolled all our 2K server versions of instcat back to the original (SP4) and implemented this wrapper. This hasn't failed yet. But a...

READ THIS RUN THIS It works !!!

Thanks Marek(Legend) Adamczuk

CodeOn:P

Glen (4/11/2008)

---

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=62887&SiteID=1

Excerpt from the article:

"When running 4 part reference query like this:

select * from sql2000.mybase.dbo.mytable

SQL Server 2005 x64 runs the...

• This reply was modified 5 years, 7 months ago by  Malcolm Daughtree.
• This reply was modified 10 months, 1 week ago by  Robert Chipperfield (Redgate). Reason: Requested by original author

Opps :blush: Wrong version.

Thanks for that.

CodeOn

😛

If you only need to administer the SQL servers then installing the client tools only is free. And this is just my humble opinion but its a bit rich...

BOL is an important resource.

reference

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/6e929d09-ccb5-4855-a6af-b616022bc8f6.htm

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications...

I hope you have a backup of Master and the other databases. If you can't restore master, you will need the installation media and run rebuildm.exe to restore the master...

All java'd up and ready to rock ! Yeah ! Sorry for the tirade and I know not all our issues are Manigerial just seems like it 🙂

CodeOn

😛

sitting on the bus pondering the world of data and the conversation here and it struck me, we all very able and competent professionals. and yet the main issue is...

My Absolutes

1. Backups, Backups and just in case it was missed Backups.

2. No 'sa' access (My sa password is 128 random chars) Security groups and Integrated Security where...

Wow Jeff ! you said a mouthfull !! And yes I'd agree on the NO ACCESS. Why ? because it is the calls at 1.00am (Local time)...