I was missing something! I did not notice that you had both the column name and *.

Thanks.

I'm a bit confused by your last example. Your update does not show anything being updated. It sounds to me like your business key is Project_ID, Product and...

I'm not sure of the answer here, but I see that this post has been sitting out there quite a while.

An easy way to find out would be...

I'm not sure I follow you 100% here. Can you give an example of how you want to call the SP and what you expect to be able to...

nwlibrarian (1/9/2009)

---

Quite honestly I wouldn't fight with it. I would restore the database under the original name "cbs_test"; then right-click on the database and rename it. It should make the...

I am not aware of it being depricated. It exists in SQL Server 2008 as well.

Yet another way, using Matt's example to build on.

create TABLE #temp (ID INT IDENTITY (1,1) PRIMARY KEY CLUSTERED, ServerName sysname, DBName sysname, Size int, ReadingDate datetime)

EXEC sp_MSforeachdb ' USE ?

INSERT...

Mike and Chris are absolutely correct. You need to explicitly list all columns that you want to select in the SELECT clause of your statement. This is just...

rtbhosale (1/9/2009)

---

Yes you are right.

I have tried the BULK INSERT by using .csv file it is working correct.

Because i have not specified the KEEPIDENTITY attribute it was giving incorrect result.

Thank...

Would you mind if I asked why you would want to do that anyway? Is this for a report? Are you planning to reference the value as a...

It sounds like you're aware of this already, but it's worth mentioning. Depending on the insert volume and size of these tables, adding the clustered index on a GUID...

1. Create New PK on parent table.

2. Drop FKs to child tables.

3. Add new parent PK column to child tables.

4. Update Child table with new PK value from parent -...

Glad to help.

OK, sorry. Here's a bit more info into the interworkings of this.

First, the Result Set tab on your Execute SQL task to get your hosts needs to be set...

This one is fairly straight forward. In fact, there is a good exampe out on Pragmatic Works web site that I don't have time to locate for you. ...