Let me know if you do remember - would love to check it out 😀

thumbs up

Barry: Nope - not even in 2k8! 🙂

Output from ssms 2k8 after sp_rename 'proce', 'procm':

CREATE PROC

[dbo].[procm] -- schema

.

proce -- procname

AS

print 'hello'

GO

I don't understand. Please take a look at the proc I supplied to you.

And please don't post the source to the same proc again, I honestly don't have the time...

Elliott W (9/22/2009)

---

I have had pretty good experiences with TFS and Vault. I have been working with ClearCase and I hate that one, it usually works but not always...

I can try, but I really don't get what it is you're trying to achieve?

Why don't you create the proc...

I must admit, i haven't read your post. But here's a proc I use to perform a similar function

CREATE PROCEDURE [dbo].[stproc_WebPlatform_ReturnDataRows]

@TableName varchar(256),

@offset integer = 0,

...

Elliott W (9/22/2009)

---

VSS isn't terrible, but it isn't great either, especially if you have to pay for it. There are a lot of alternatives, all of my favorites use...

Wow, that procedure is horrific.

1) Don't use cursors unless you *really* can't find a way around it.

2) The output parameter is a cursor. BOL gives a good example. http://msdn.microsoft.com/en-us/library/ms186256.aspx

3) Don't...

Can you run this please?

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

There's no way to do it in DMO directly AFAIK. I do it in one of my products, and it's not easy. You need to write a lexical parser for...

Lynn / eko

No probs - glad to be useful! 🙂

Edit -> sorry eko - just one more thing - make sure you read the bit about 'types implemented after 2005'...

I feel your pain.

You know you will remember it at about 2AM, then you'll fall asleep and have forgotten by the morning!! 😀

Just a question - do you get any better performance loading into a temp table?

Hmmmmmm....

Let me explain it a bit more clearly for you.

Indexes are effectively like cards in a library. You might have a library card set that is sorted by author. You...