I would suggest two changes where you declare the cursor:

declare db cursor for

select name from master.dbo.sysdatabases

where name not in ('master','tempdb')

and charindex('-',name) = 0

and version 0

Checking the version prevents trying...

A friend of mine wanted to conduct a license audit of her installation and used sysprocesses to get the info. On each server she created a DTS job that...

I've been thinking about this project, it looks like I might actually get to do some work on it soon. I think I'm going to do a "logical split",...

It's rare that I have easy problems because I try my best to resolve 'em before I post here! 😀

All of the users are NT authority. I add them...

Now THAT was a clever retaliation!

Talk about hoist by your own petard! :hehe:

Bob Abernethy (4/1/2009)

---

Before leaving home this morniing, I HAD to booby-trap the spray hose attachment on our kitchen sink - by wrapping a rubber band around the handle so it...

Steve, I think you might have a lingering conversion issue when you took the site to MySQL, I had terribly long load times when I was trying to access Erik's...

John Emil Halleland (6/22/2005)

---

Hi

It seems like you are installing SP4 from an UNC path.

" "

Try mapping that path to a local drive and run SP4 setup.bat from the mapped drive.

John...

I have to write the front end application for it, that's the only thing that VB applies to. It would probably make no difference what language I did it...

That was my understanding, but that could be old (pre-OS X) or inaccurate. I've always wanted to work with Solaris, but I've never had the gumption to really buckle...

Thanks, Lynn! I can never keep 'em straight. 😀

Bleh! I remember writing file updates for such sorted layouts in Fortan and Cobol: not much fun! But it is an excellent illustration as to why you can...

Hey, Paul. I had to re-read the thread to refresh my memory!

Did you follow the steps I mentioned on my second post on the second page with the y.dat...

Manie Verster (1/16/2009)

---

... Just to help you right. By salted (remember I am an Afrikaans (Dutch) speaking South African) I actually meant knowledgable or trained. Salted is a word we...

Nope, not an industry that should have a seriously high level of security. Personally I think that root password should be longer than 10 characters, but it would be...