SQL Server Tools

Hi: In 2000 EM I was able to create a single maintenance plan that would back up the dB on a specific schedule and back up the tlog on a different schedule, and automatically delete backups past a certain date. ...

Hi! I'm looking for a way to retrieve Licence Info from SQL 2005 Server with VBScript From a remote location I connect to the server and grab those info with my administrative rights, but I'm not accessing the DB with a SA account... ...

Question, I just came from an ms sql 2000 enviroment to the new 2005 sql server management studio. In 2000 enterprise manager, if I wanted to update some data quickly, I could expand the database tree on the left side of the app... right click on any table and select "Open as ...

All, I have posted this to other listgroups without resolution so here goes..... We have a system with over 400 jobs.  We have 3 environments dev, MO, production. The developers create and test the jobs in development and then the DBAs ...

Hello! anybody know some tool to synchronizate data between databases (two databases has the same structure) . I can not use replicate becouse I have not a permanet connection between servers. Now, somebody can send me a backup peridocally using email. And I can restore in a second database in ...

Am running a SQL Server 2005 Ent IA64, 2 node (active/active) cluster on Windows 2003 Server Ent with SP1 IA64. Everything working ok, but everytime I launch the SQL Server 2005 Management Studio, the following is logged in the ...

I was working originally with what turned out to be a very unreliable offshore IT firm in India. I had to finally severe our working relationship with them. The were about 70% complete even though that demanded 100% payment upfront. My problem is they site me all the site files and a data ...

I have two separate servers with SQL 2000 installed. Simple install and no replication. Server A is production and is running SQL Server 2000 Standard Edition Server B is development and is running SQL Server 2000 Standard Edition Both are on the same domain. ...