I was wondering if anyone had a script which notifies you when locksprocessid's are blocked?
Does anyone if it's possible in SQL Server 2000 to monitor what users are doing against certian databases via a script?
I have alrady setup SP_Helprevlogin. The next thing I need to do is script out the permissions.
I am trying to create a sql script that when run will recreate all or SQL ServerNT logins. Plus add the database permissions in the event of us...
Does anyone know of a tool which enables you to automate scripting out sql server 2000 maintenance jobs?
Thanks for you help Satya
Does anyone know if it's possible to configure SQL Mail on a 2 node SQL Cluster? The server we will be using has Windows 2000 and outlook 2003...
I have now managed to solve the problem. I had to switch off the enforce password expirations in sql server 2005 logins to solve the problem.
I've seen this article. Both servers are configured for mixed authentication
I did, but it keeps coming up with an Error 18452 Login failed message. I can however successfully link it to a 2000 server.
But is it possible to create linked servers between 2005 & 2000?
Does anyone know if it possible to create linked servers between sql server 2005 and 2000?
Has anyone out there used a piece of software called Log Parser before? I am trying to import out IIS log files into a sql server database, so that...
We currently have a sql server 2000 installed on a 2 node windows 2000 cluster and I wondering if it was possible to configure sql mail on a...
It's for our web database server and because there are different people creating jobs it very hard to keep track of what people are doing.
I would like to setup and automated system, so that all our sql server jobs are scripted out on a daily basics.
Has anyone done this before? Could...
Separate names with a comma.