I had to deal with this last year. Sadly, they both have to be the same version.

I have been a DBA for 10 years now and I never use the DTA. In my opinion, if a person cannot determine whether an index is needed, and what...

Here's a useful tool I used to use to get a quick inventory of all the SQL, SQLExpress and MSDE instances on my network: http://www.specialopssecurity.com/labs/sqlrecon/

It's free and very...

That one works!

Thanks!

Hi, Manish.

I turned an email I wrote -- based on your post -- to a colleague (ETL designer) into a blog post on my site here, and cited you....

I believe the WHERE clause here:

Where indid < 2

means that it's on the clustered index. So wouldn't it alway be accurate regardless of statics, since that's the actual...

If you make the mistake of detaching a suspect databases (as I did in my younger days) and you are pretty sure it IS corrupt -- since you cannot re-attach...

James and Jim,

The bug you reference (http://www.sqlservercentral.com/blogs/james_howards_sql_blog/archive/2009/12/04/data-collection-set-3-upload-failing-its-a-bug.aspx

) is not the same one as the one that Casper101 mentioned above.

I too have this error:

--------------------------------------

Log Name: ...

Yes.

How about something like this:

with DateCTE as

(

select cast('01/01/1998' as datetime) DateValue

union all

select DateValue + 1

...

Hi, Gift.

Thanks for your response.

I don't really understand what VS2008 would have to do with it since the Server that can't connect (MYDEVRPT01) only has Reporting Services 2008...

Nice article. I will definitely print this one out for lunchtime reading.

By the way, someone contacted me with a corrupt database a couple of years ago (they had NO...

Hi, The best advice I can give you is get a copy of The Microsoft Data Warehouse Toolkit and read Chapter 1 through Chapter 6. It will save you so...

Andy Brown has a nice custom backup stored proc I use sometimes at http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/31640/[/url].

I tweaked it a bit by adding this code about a third of the way down:...

See if this does what you want. It seem to work for me in SQL 2000 and 2005.

/* Script to Reverse Engineer SQL Server Object User Permissions */

/*...