I am not sure how you are going to do this in VB; but make sure the VB script sets the property using the SQL Server Configuration Manager (SSCM) and...

You can use linked servers to poll information from all the servers.

Create you new CentralJobHistory table on server of your choice. (S1)

Create a new login on each of the instances...

I haven't used MySQL for so long I can't even remeber that ... thanks! I'll have to tell them next time LOL ... the biggest reason everyone gives me...

I don't think you are going to find a easy answer...

Look at following:

http://www.microsoft.com/sqlserver/2005/en/us/overview.aspx

http://www.microsoft.com/sqlserver/2005/en/us/features.aspx

http://www.microsoft.com/sqlserver/2005/en/us/technologies.aspx

and write something up .. but I don't think you can buy 2005 any more.. (I might be...

Here are a list of issues fixed in 2000 SP4...

http://support.microsoft.com/kb/888799

Thanks.

I am taking a guess it is an Active Directory group... So in Active Directory remove that person from the group and they will not be able to access it...

What are you trying to do Raj? See what is in the Inserted table in for the trigger?

Mohit.

Urg .. Not a long rant but why do people have in their mind SQL Server backup is not online?

Everyone at my work seems to think that to, I have...

Actually I am at 80 databases LOL; urg.. I forgot stuff heh. And we are running high-avaliablity mode. If you like log shipping you should love mirroring too,...

I have over 30-40 databases running on my SQL Server 2005 server with no issues; have you seen...

homebrew01 (3/16/2009)

---

Thanks for the replies. Most of the tables do not have clustered indexes, so I guess the HEAP cannot be defragmented. As for the others,... I had built a...

Yeap :). SQL Server uses local groups to grant permissions so most of them are there. If you change the service account the tool adds the new service...

Hey ..

Your query is correct for selecting text but that text must be parsed properly to mean anything please look at the query below:

[font="Courier New"]     SELECT deqs.last_execution_time AS [Time],

            SUBSTRING(dest.TEXT,

                      (deqs.statement_start_offset/2)+1,((CASE deqs.statement_end_offset...

Could you list the output of the DMV here please for the given table?

Thanks.

I recommend to learn this you play with clustering over virtual environment 🙂

Have a read: http://www.microsoft.com/technet/prodtechnol/virtualserver/deploy/cvs2005.mspx

Thanks.

Mohit.