Excellent article. I was wondering if you had any additional comments regarding SQL 2005 and 2008? I realize that in general the situation is the same. An...

Actually it ends up being 2 seperate subjects. To the first, the account trying to run the WMI call has nothing to do with the SQL Servers, but I...

Its actually a series of about 30 servers, the SQL Servers are sometimes running under service accounts and sometimes local system. I'm working to convert them all to service...

select count(*) as [Total-Matching-Records]

from member_view mv , eligibility_current_view ecv

where ecv.environment_key = 'DL'

and mv.environment_key = 'DL'

and mv.commencement_date = '20100601'

No that sounds about right. mv.commencement_date = '20100601' affects only the number...

Unfortunately to really say what's going on we would need the table structures as well. At the very least the primary key/indexes, and preferably some sample data. Not...

There are of course a number of different system views that you can use (and just to note everything I've noticed in the above post has been system VIEWS not...

Thanks guys. I love finding out about those fun little xp/sps 🙂

There is also as of 2005 a view called sys.procedures you can use. However don't forget to tie in to sys.schemas as your procedure is technicall named schema.procedure_name even...

Part of the problem is that your question is very difficult to read and to understand what you are trying to do.

If I understand correctly you want to create a...

One additional thing to consider is what is the order of your data? If the order of the data you are inserting very closly matches the clustered index then...

On the assumption that by "exception" you mean the row failed, you can redirect it to another location (excel or table is fine) fairly easily. Its done in the...

singhsatnam84 (8/12/2010)

---

Also i have one stored procedure, before the stored procedure starts it has the following piece of code:

USE [Database Name]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

Create procedure proce_name

as

begin

T-SQL

end

When i again click...

ziedkallel (8/11/2010)

---

Just a follow up question. What if the ConceptID column is empty in some rows in the descriptions table, how to do the join? I'm realizing that a long...

First things first, are you sure you saved your package from the wizard rather than just executing it? If you did where did you save it to? Did...

I think you are going to have to create a temp table to load the data into. Load the data into a table along the lines of

CREATE TABLE temp...