It's giving a syntax error, soit's probably not a permissions issue. What is the directory path into which it should be creating the directories? And what is the name of...

Here's a simpler approach:

Select ColLIst

FROM dbo.TableName

Where (SomeCol1 = @Par1 Or @Par1 Is Null)

And (SomeCol2 = @Par2 Or @Par2 Is Null)

And (SomeCol3 = @Par3 Or @Par3 Is Null)

And...

Not true. You can use a table variable .... though SDM's query is definitely the better way.

Your windows account, when not in a domain, is MachineName\UserName. MachineName is the name of the computer itself, not the name given to the SQL Server instance. If you don't...

Quest has a new product out that I'm currently evaluating called SQL Server Capacity Manager. It tracks all of your usual performance stats at multiple levels (server, database, table) and...

Nice description!!

One thing that comes to mind right away is that I think you should consider doing this with SQL 2005. There have some major improvements that really benefit data...

1. When posting about an error, please post the error message. The exact error message, not a description.

2. When you say calling the function on it's own, do you mean using Execute dbo.fn_GetColumn....

You'll have to do some scripting, but you can zip the log file after the backup and unzip it after copying it to the standby server. There are lots of...

I just want to point out that it is not possible to have a before insert trigger that modifies the record that you haven't yet inserted.

Did you change your compatibility level to SQL 2005 (90)? You can not query that system function if you are running in SQL 2000 compatibility mode.

To check current level:

Well, now we certainly have ground to agree on there!! Although I think it was a good move to combine the functionality of EM and QA into one, I think...

Yes, that is a new schem option in SQL 2005. There are a lot of new options!!

Is this what you are looking for:

sp_refreshsubscriptions

Add subscriptions to new articles in a...

I couldn't disagree more!!! There are a lot of great things in SQL 2005. You couldn't pay me to switch back.

Here's a great thing that you probably don't even know...

The reason it's not using the index is that you are looking for a range. Because it is not a clustered index (physically stored in order), the only way it can find...

Also, try specifying the owner name with the procedure call like you did in the procedure. My guess is that there is probably another version of this procedure in the...