We go through the same worries about SANS all the time. You're completely dependent on your SAN admins to set up the drives appropriately and maintain them well. If your...

Oops. Serious egg on my face. That's new for 2008. It won't work with 2005. Sorry.

Gail's 100% correct.

I've got some 64 bit servers and I haven't seen this behavior, so I don't think it's the 64 bit alone that's causing the issue. Are there any...

Take a look at the services running on the server. Analysis Services, the OLAP engine, is completely different than SQL Server. That will till you which you have. However, you...

This is from BOL. I'd suggest trying it.

SELECT referencing_schema_name, referencing_entity_name, referencing_id, referencing_class_desc, is_caller_dependent

FROM sys.dm_sql_referencing_entities ('Production.Product', 'OBJECT');

First thing I see, do you reall need to do a left join to that sub-select. If I'm seeing the logic correctly, it's looking for any of the values that...

And then only if it's a publicly traded company. I've been working for a private company for years, so I'm only aware of SOX when I hear people complaining about...

You don't have to create the shell to restore a backup to a new database. You just have to move the data files. I explained the GUI method in the...

I am such a dope sometimes.

http://www.sqlservercentral.com/articles/Backup/recoverytoapointintime/1914/%5B/url%5D

It sounds like your maintenance plan is set up right. The scenario you described is not because of a database or log first or second, but because you have to...

Maybe I'm confused (hardly a new case), but however many log files you've backed up, you'll have to traverse them unitl you get to the log where the end time...

You can't really do logs first. You have to restore the database and then a series of logs and the backup has to be in the same order.

Those files are not compatible with Management Studio.

As to where... it really depends on your shop and the processes there. For example, we use Visual Studio Team System Database Edition...

Didn't I answer this one already today for you?

http://www.sqlservercentral.com/Forums/FindPost562957.aspx

But the issue is the error message:

"nvarchar value "2147486776" overflowed an int column"

If you're selecting into a bigint variable from a big int column, where is the nvarchar and the...