Putting my audit hat (CISA) on...

On any of your SQL Servers do you have 3rd party applications (or even home grown applications) which connect via SQL authentication? If so, can...

Did your permissions change on the server?

Are you a member of the sysadmin fixed server role?

Did the password for the SQL Server service or the SQL Agent Proxy account change...

Roy Laws (10/27/2006)

---

I am having somewhat of the same problem, the error I get is <Access to the registry key 'HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell' is denied>. I am in the local...

Is anything still executing the DTS package, such as a SQL Server Agent job?

In SQL Server 2000 there isn't a role that will give you EXECUTE rights against stored procedures and UDFs, but you can create one fairly easily. To address this problem...

I wouldn't put tempdb on the system drive. The system drive is going to get tagged hard as is with I/O. Also, you don't want a situation where tempdb fills...

On a related note, it looks like Red Gate is coming out with a tool called SQL Multi Script in the next couple of weeks that handles this sort of...

I know this is posted in the SQL Server 7 and 2000 section, but we see posts in the wrong areas all the time. Is the SQL Server you are...

That's an operating system file... first showed up with IE5. Do you see a file by that name in C:\Windows\System32 where you are running SSMS from?

kkline (11/12/2007)

---

These are great suggestions, Andy.

I've actually been planning to work on a certification program for PASS for some time now, once I step out of the role of president.

Look...

The biggest issue that's being discussed is due to some end user executing a SELECT...

It depends. As the old saying goes, "You get out of it what you put into it."

If you're just looking...

It looks like you lost your LF/CR when you copied the script. GO and CREATE should be on separate lines... it looks like all of them were stripped.

vinuraj (11/12/2007)

---

Its Quite Interesting to Answer this

well you see

you are not interested to do certification

you have very good experience

but doing certified

You surely still learn more and will get...

Joe Clifford (11/11/2007)

---

Sounds like you've got to do some DNS work - with the servers in different domains, etc. it's no wonder that you have to use an IP address...