Jeff Moden (4/10/2012)

---

simonrichards74 (4/10/2012)

---

Hey, hope I am not stepping on anyone's toes here.

I have been looking into setting this up, so documented my steps and submitted an article.

It...

Hey, hope I am not stepping on anyone's toes here.

I have been looking into setting this up, so documented my steps and submitted an article.

It is my 1st,...

Agreed, I only picked up PowerShell a few months back, but it has been a life saver.

It has...

yeah, this was installed before my time (just started last month), one of those 'let's go and see what's out there......oh crap' situations.

Thanks for the help, very much appreciated. 🙂

Thank you Perry, I'm good with installing it, just wasn't sure about installing after the system went live. It won't cause any issues installing after the fact then?

Thanks again for...

might be some form of corruption as now when I try and run the proc that does the insert I am getting:

Could not find database ID 4023. Database may not...

Thanks for the reply, sorry I meant our instance not 2008 generally, wondering whether it was a bug or something.

weird thing is now it is doing exactly the opposite on...

Thanks for the reply!

I have switched to Simple as it is a staging environment which saved me a bunch of time.

I have actually solved the problem by adding an int...

Found the issue in case anyone comes across it again.

There was a default set for a UDF that used the function suser_name(), apparently in 2000 this returns null, but in...

Thanks, I had come across this article in my searches but it seems unrelated to what we are experiencing here. I was wondering whether it was permissions on the tempdb...

Thanks for the reply, I have checked the data getting posted (in fact it returns no rows at all) but it is all ok, the issue seems to be because...

Thanks for the links Rob, much appreciated.

Hi, I use the following as an active x script from a job on SQL 2000:

Dim conServer

Dim fso

Dim iFile

Dim oJB

Dim strJob

Dim strFilename

Const ioModeAppend = 8

Set conServer = CreateObject("SQLDMO.SQLServer")

conServer.LoginSecure = True

conServer.Connect...

I can't find anywhere this is stored by default, but this article shows how you can configure it manually:

http://www.mssqltips.com/tip.asp?tip=1574

hope this helps.

Thanks G, nail hit firmly on the head there.