Post @ http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=49&messageid=97068#bm97086

Sin,

I have a stored procedure I've been readying to upload into this site's Scripts area. Have not done "complete" testing on it yet, and also a little worried if it's...

Martin,

An "alternative"...

Usually I prefer to use #Temp table to "move" data between scopes.

They become an "array" of variables to manipulate data through.

They are also nice because you can then very...

NP, not much happening on Saturday in the formums huh? Thought since I'm at work because of internal net change stuff, I'd check to what's happening here.

I do not...

Henrik,

I guess it depends on your "setup" and "usage" of the DBs & Server(s). In my case, individule DBs get moved from server to server alot, and / or backups...

Martin, here's a little example code. You'll need to change some of the @sql = stuff, but it will run as-is against [SYSFiles] table of local DB. Hope this helps.

Create...

Thanks Mike, sorry it took a while. I SELECTed INTO #Temp the recs, TRUNCATEd Table, Backed up, DBCC SHRINKDATABASE, INSERT .. SELECT FROM #Temp.

Worked fine, brought the DB down to...

Agree Gary, it can be simply limited with SELECT ... WHERE LVL < n in the ELSE portion.

I was also thinking, maybe not use #Temp for all recs, but just...

While Gary was posting....

-- Example (No "level" limit) possibility

-- May want to modify for performance & other reasons, but I hope the "jist" gets across

-- Build test data

If object_ID('NRGroupsTest') is...

Thanks Steve, I don't do it often enough to retain it in my ever deteriorating brain cells. It's tough getting older.

As long as the "CREATE VIEW...." statement is the only statement in a script you can create views in T-SQL using dynamic sql....

Declare @sql Varchar(8000)

Set @sql = 'Create View [ViewName]...

There is an easy answer to this.... but it escapes me for the moment...

Someone will post it... it has to do with the master.sysservers table entry etc... only takes a...

Tried your code Gary, and plain old

sp_addlinkedserver ..., @srvproduct = '', @provider = 'SQLOLEDB',

sp_serveroption(s)...,

sp_addlinkedsrvlogin

Both ways produce no errors even if remote server does not exist.

Once I try...

Hey, I just like clicking on  + & -  signs

Thanks,

Seem to be able to edit every time now.

A bit slower load now maybe (could be my end).