SQL Server Tools

We are running four servers at different sites say A,B,C and D and want it to connect main Server at head office what would be the configuration of main server for running SQL Server 2005.There are two ...

When I press Start Analyis in the wizard, I always get this message: Microsoft Visual C++ Runtime Library Runtime Error! R6331 -Attempt to initialize the CRT more than once. This indicates a but in your application. The first step starts to run (Submitting Configuration Information), but it ...

No more Query Analyzer, fine, but why did they remove keyword coloration? Is there a way to get it back? Paul ...

Super Help, I would like to restore a database and I tried everything! use master RESTORE DATABASE Test_prod   from disk= 'e:\MSSQL\BACKUP\TESTSANDBOXBACKUP.BAK'    WITH RECOVERY -- Apply the first transaction log backup. RESTORE LOG Test_prod    from disk= 'e:\MSSQL\BACKUP\TESTSANDBOXBACKUP.BAK' ...

Upscene Productions announces a Spring Sale with 25% discount on all database developer tools! Currently available from Upscene Productions: Database Workbench A multi-database engine development IDE, currently supporting Microsoft SQL Server, Oracle, InterBase, Firebird, MySQL and NexusDB. IB LogManager Suite ...

Is there a way to generate SQL for multiple objects through Management Studio? Also can you generate a drop with a create or a create only? TIA - Jeff. ...

Is there a way in Activity Monitor where I can select which columns to show or not show? ...

Free Online SQL Formatter which can beautify different sql dialects for you on the fly, and translate to other languages such as C#, Java,Delphi with many format options. Try it here: [link] ...

Hi I'm sure somebody else has asked this same question, it's pretty basic I develop an app using SQLServer, now I need to install the app in my boss laptop to make a presentation. 1. Do I need to install the whole SQLServer from the installation CD or It ...

Can a SQL Server 2000 server enlist as target server to SQL Server 2005 master server? When I try it I get the message "The master server version 9.00.1399 is not compatible with the target server versions 8.00.760". ...

SQL 2005 When modifying an existing Maintenance Plan and then saving it, I get the following error: --------- Microsoft SQL Server Management Studio Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx) -------- I didn't find anything in the KnowledgeBase ...

Running on XP Pro SP2 Installed SQL2K Enterprise manager When I look at the table view in detail layout in the top 'name' column right beside where it says name there is a folder icon and each time i click ...

I've inherited an interesting one :- An application currently produces about 150 .csv formatted reports that I need to import into a SQL database to run reports, etc on. Simple enough but here's the kicker :- The applications works as follows :- ...

I'm looking for a counter that will help me identify which indexes are used and how frequently they are used.  My goal is to remove indexes that are not used. The number of transactions on our database makes it impossible to store ...