Duplicate post. Please post answers in this thread: http://www.sqlservercentral.com/Forums/Topic649461-338-1.aspx

If this is a one-time thing why not download a product like RedGate SqlDataCompare or ApexSQL SQLDiff to transfer the data? If it is done regularly why not buy...

Thanks for the nice comment on the article.

Well, based on what I have seen about INSTEAD OF triggers using them to make views updateable seems to be the most...

Somebody has to tell me how I get one of these.

I recommend that you read this excellent blog post[/url] by Gail Shaw (GilaMonster on SSC) and then this one as well. You may need to create an account or...

I have never come across an instance where I found that INSTEAD OF triggers were necessary. Why are they proposing INSTEAD OF triggers?

If you check out the discussion of...

What code is creating this global temp table? Any process trying to create another global temp table with the same name should error out with an error like this:

Msg...

Read the link that Michael provided (also in my...

Please read the article.

Thanks,

Mike's solution is probably going to perform better because you only hit the main table 1 time so I'd go with that, which, once you replace the temp table with...

Assuming you are doing an:

Insert Into

EXEC [procedure]

There is no way to do limit the columns returned by the procedure unless you add a...

This works, but is probably not ideal:

Create table #Select (id int, Name varchar(10))

Insert into

#Select

values

(1, 'Test')

Insert into

...

The status column tells you if a trace is active. The only possible statuses are 0 - stopped and 1 - active. This is alos property 5 from...

Well, you can change the names of folders to include more information. Of course you will need to note these changes so that when you deploy changes or new...

What do you want to sort by? If you go to detail view you have some sort options