You'd have to have some looping mechanism to find the places where /* and */ are, position I mean and then substring them out.

So

create procedure myproc as /* test */...

What's the query?

Connect to SQL with QA

Rename the windows install

issue an

sp_dropserver (old name)

go

sp_addserver (newname), local

And reboot. Should be good to go.

Interesting idea. AFAIK, none of the site owners are bilinugal, so comments in any language are unreadabvle by us. I typically don't review the scripts when they are submitted because...

Using sp_who, which queries the system tables it NOT accessing the system tables. The reason sp_who is available is precisely for this reason. It is guarenteed to work in future...

I'd agree with the above. Load into SQL and then dedup.

There isn't a good way natively. Products like Red-Gates and others allow you to do this fairly easily, but you have to do it. I think some of them do...

You'd need to code something in the DTS package to look for the change in the file.

If you upgraded and were using Identites, then it's possible that some numbers were lost. Depending on how many times you upgraded and rolled back. And depending how you...

You will need some type of process to download the data. This probably needs to be via HTML, XML, or even csv. One thing you have to be sure...

You don'tneed to restore the dbs. Use sp_help_revlogin (from MS) to script logins. Uninstall. reinstall, and attach your databases. Run script to load logins.

Step 2 may not do it. If it doesn't, try this:

http://www.sqlservercentral.com/scripts/contributions/26.asp

The above is the most likely cause. The stored procedure creates a cursor in each database and uses that to gather information.

I think horzintal partitioning can be a database design technique, but I'm not sure I'd recommend it in your case. I've used it in places where we had a wide...

Had a request and it was a quick one, so I did it. Glad you like it.

Keep sending suggestions!