Viewing 15 posts - 5,401 through 5,415 (of 9,643 total)
kruti (4/13/2009)
Ok. so pointer is again come to first question of this post.Why it is giving error in his execution?
It's hard to say because as I asked in both of...
April 13, 2009 at 9:00 am
jcrawf02 (4/13/2009)
GilaMonster (4/13/2009)
And what's the longest flight you've been on? I'm pretty sure after a 20 hour trip without changing planes you'll be saying a different thing.
Yeah, no doubt I...
April 13, 2009 at 8:56 am
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...
April 13, 2009 at 8:54 am
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...
April 13, 2009 at 8:03 am
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...
April 13, 2009 at 7:23 am
RBarryYoung (4/13/2009)
Florian is a "she"?!? :blush: Man, it is so embarrassing to get that wrong...
I did the opposite with Lynn (Pettis) about a year ago. Of course...
April 13, 2009 at 7:21 am
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...
April 13, 2009 at 7:15 am
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...
April 13, 2009 at 7:08 am
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...
April 13, 2009 at 7:04 am
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...
April 13, 2009 at 6:45 am
What account is the SQL Server running under?
Is the provider for Active Directory installed on the server?
April 13, 2009 at 6:38 am
From BOL for @@error:
Returns 0 if the previous Transact-SQL statement encountered no errors.
So as soon as you have a statement after the error then the @@error returns 0.
If you are...
April 13, 2009 at 6:34 am
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...
April 13, 2009 at 6:16 am
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.
April 13, 2009 at 6:01 am
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.
April 13, 2009 at 5:59 am
Viewing 15 posts - 5,401 through 5,415 (of 9,643 total)