SQL Server Tools

Hello,    I do all of my SQL Server administration remotely from my workstation and i noticed that the green running status symbol was blank on one of my MS SQL 2005 servers.  I also noticed that when i right click on the server name my ...

Hello, I'm running a SQL 2005 Standard Edition (x86) clustered with SP1 applied on Window Server 2003 Enterprise Edition, SP1. We have some maintenance plans to backup databases and transaction logs to disk (each database goes to a subfolder).  Part of that maintenance plan ...

I was forced to reinstall SQL Server due to a fault in the Full Text Engine. I removed everything and got the message: "A component that you have specified in the ADD_LOCAL property is already installed. To upgrade the existing component, refer to the template.ini and ...

Hi All, Hope I've picked a suitable group for this. Couldn't find a group dedicated to performance/optimisation. I'm using OStress to replay a number of RML files against a 2000 database. I keep seeing a number of errors coming out similar to: ...

Can anyone suggest how to deploy Sql Server Clr project using MSBuild? I have used Visual Studio 2005 to create a Sql Server Project.  That project contains C# code that I deploy to my Sql Server database to run on the ...

Is it still impossible to run Management Studio for SQL Server 2005 and Management Studio Express on the same machine or has that been fixed? I would like to install SQL Server 2005 Express Edition with Advanced Services but the last time I tried that, it overwrote my Management Studio ...

I can't figure out why the Profiler is not showing any values in the column DBUserName. Any ideas? ...

I could successfully upsize all TABLES of an Access2002 database to SQLEXPRESS. How can I export/upsize Access Queries (which are many and useful)?? Newbie seeks help. Thanks ! ...

Hi Is there an easy way to drop all object of a db so it is as new? Just so I can run a script to recreate the objects. Thanks Regards ...