SQL Server Tools

Hello: I have uninstalled SQL Server 2005 Studio Express Edition so that I could install SQL Server 2005 Management studio on this server. When I try to install the Studio, I get the following error message: A component that you have specified in the ADD_LOCAL property is already ...

I am used to DTS packages in sql server 2000 and now I want to use Integrated services to create 'DTS' packages. Going to a .net users group meeting, I was told to use  the 'Advanced editor' since it would help me alot. However, I ...

I like to use the copy database tool to copy 15 databases from a production SQL 2005 64 Bit to a test SQL 2005 64 Bit system. Is there a documentation specific about how to do it? ...

Hello,     In order to utilize an Access database as SQL Server database I use Upsize wizard. I use (Local) SQL server and Trusted Connection. After some wait I get the following error:         Connection failed: ...

A friend is trying to use the Database Maintenance Plans to build maintenance jobs for her databases.  She is using SQL 2005 Ent Ed.  Her account is in the system administrators role.  She can back up the databases by writing the SQL ...

I have a job (owned by "cod\SqlAgent" which fails running the following statement: EXECUTE master.dbo.xp_sqlmaint N'-D msdb -WriteHistory -CkDB -BkUpOnlyIfClean -VrfyBackup -BkUpMedia DISK -BkUpDB \\itdsdgprd01\Backup\SQLCA  -DelBkUps 23HOURS -CrBkSubDir -BkExt "BAK"' The job succeeds when i assign appropriate read/write perms to the account ...

On a new build of a laptop, I've installed Enterprise Manager, rebooted, then installed SQL2005 Management Studio. Everything was fine. Then I installed SP2. I find that within Management Studio, the "New Query" button brings up a query editior, but I cannot input control characters (new line, backspace, ...

I am looking for a tool like this to use on an Oracle 10g database I have but since I am not a big Oracle guy do not know of any decent options.  Can anyone recommend one?  Thanks ...

I was running a profile trace for a client SQL Server 2005 Standard Edition, SP2. The duration for some of the statements was just under 1 minute, however for the same statements the difference between the starttime and endtime were closer to 17 ms. ...

I was able to search for column names (among many other things) in SQL Server 2000 when I was in a query view.  Is there a way to search by a column name in database in 2005? Thanks. ...