It's hard to say because as I asked in both of...

jcrawf02 (4/13/2009)

Yeah, no doubt I...

I'd just check using SSMS for the ADsDSOObject in the provider under the LinkedServers Providers node to see if the provider is installed.

What is the security set on the ADSI...

Tracey,

ROW_NUMBER is one of the new statistical/windowing functions added in SQL Server 2005. Basically it created a sequential number based on the OVER clause. In the current situation...

No, I didn't give up, but I had Friday (the 10th) off because it was Good Friday and then had the weekend, and I don't do much with SSC on...

I did the opposite with Lynn (Pettis) about a year ago. Of course...

You would need to use dynamic SQL and the best way, in my opinion, is to use sp_executesql.

Also check out this blog post about SQL Injection

One "problem" with your query...

Can you please provide more details, especially the code (at least code that approximates it) that is generating the error?

Without knowing what you are trying to do there is no...

Laerte has the right idea. Here's how I would do it.

1. Create a calendar table that has flags for holidays and weekends

2. Create a job that runs...

When you look at the properties of any database by right-clicking and selecting properties, the # of users shown is the number of users created in the database (have access...

What account is the SQL Server running under?

Is the provider for Active Directory installed on the server?

From BOL for @@error:

So as soon as you have a statement after the error then the @@error returns 0.

If you are...

So basically you want to create a comma-delimited list to pass to the IN clause of a query. You can do this using FOR XML PATH. Somthing like...

I don't know of a way to do this in SSRS. If you find a solution please post it, as several people have asked this question.

FOr SQL 7, 2000 I used XPSMTP Send mail. Make sure you use IE to go tho this site as FireFox does not display it properly.