My main production accounting database has about 150 connections all day every day. The file datetime on the .mdf file for it is 1/27/2008 11:46 PM as of this writing,...

I must say, I LOVE this stored procedure. I have used it a few times and it is very handy.

I have a blog where I feature mostly SQL Server...

Hi. You can think of GETDATE() as a system function that returns a (scalar) value that you assign to your variable. In this case, either SET or SELECT will work...

I have in fact created a DUAL table in some of my databases in the past for various uses, esp. if I have to translate Oracle SQL.

Here's what it...

For me, the file opens in EXCEL just fine. The other thing is when you are creating the Excel source object in SSIS, you can created it and it actually...

Wow. What a coincidence. Today I tried to do the same thing and got the same basic error. I would like to see any responses that come your way. Right...

What about this?

How to Script User and Role Object Permissions in SQL Server

By : Bradley Morris

May 14, 2002

http://www.sql-server-performance.com/articles/dba/object_permission_scripts_p1.aspx

Hi,

Did you try using EXISTS() -- correlated subqueries -- instead of IN() along with the UNION ?

That might help, as well.

Cheers.

I am not exactly sure because I cannot see your data, but it seems to me you need to get rid of all those nested OR clauses and turn them...

Hi, Paul.

No, it's not an ad.

I am a DBA for company in downtown Portland that makes software for the banking industry. I just thought this was a good...

Great SQL Tool for Recovering corrupted databases - "Recovery for SQL Server"

I had someone from another unit of my company contact me yesterday. He had a database corrupted with a...

If you find that your database is corrupted and you need to get data out of the .mdf file (and don't have a good backup), you might find MSSQLRecovery handy....

Don't remember where I found this but here you go. Put in your master DB and rock and roll:

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

Create  PROCEDURE sp_KillAllProcesses 
    @DBNAME varchar (100)=NULL, /*database...

I find that the simpler the better with header info. I also like to put a header in the extended property of tables as as a property called "HeaderInfo."

I also...

Definitely worth learning if you are stuck in a windows world. If you need cross-platform compatibility, go for Python, in my opinion.

Bruce Payette's Powershell in Action is still the...