SQL Server Tools

How does one create an .MDF file from the contents of an existing SQL Server database? I've tried backing up the SQL database, then restoring it to an attached ..MDF database, but this doesn't work if the other database is still being ...

Not sure if this is the right group - if not could someone point me. Problem: When browsing a cube using SQL Server Management Studio, you may spend much time creating your filters, columns and rows.  How can I save all this ...

I have inherited a SQL Server 2000 database. It is obvious why some of the indexes exists. But I'm doubtful that others are needed. Is there any way to know if, when, or how often an index is used? ...

Hi, Does anyone know if there is a list of command switches available for SQL Server Service Manager sqlmangr.exe? Thanks Colin ...

Hello, can someone explain this behavior? If I make a select using the enterprise manager, I cause blocks in an table another tool is writing in. But if I use the query_analyzer no blocks happen. Does anyone know why? Regards ...

In vb6 I used the following code: ' Helper object         Set oNet = CreateObject("WScript.Network")         ' Get the user name.         sUser = oNet.UserName ...

Features of DataTime(tm) Community Client Edition include: - Connection and visual exploration - Visual Query Reporting - Extremely rich reports, with possibility to add functions, special conditional formatting and conditional pictures - Visual Scheduler which allows to recreate reports and publish reports at scheduled times ...

Prior to installing SP1 on SQL 2005 I had created a number of maintenance plans that did backups, sent notifications etc successfully.  Ever since I installed SP1 the maintenance plans still work and I can create new maintenance plans via the maintenance plan wizard only, but I can't modify ...

Are there any open source/freeware tools that will script a database and its data? I have to move a simple database from SQLS 2005 to SQLS 2000. -- I'm familiar with RedGate, but I don't do this often enough to justify ...

Hi, I have a data file that varies in no of field for each records e.g. field1|field2|field3 field1|field2 field1|field2|field3|field4 The fields are seperated by "|" and the records are seperated by '\r\n' The field values are also a varying length. ...

Hi I have two separate SQL server databases:  DB1  and DB2 Both databases contains similar tables and I have to combine some of the like tables together. If I create an INSERT INTO statement, how do I reference the DB1 and DB2 ...

Does anyone know of a tool that can generate a graphical calendar of a server's scheduled jobs? This way its easier to inspect which jobs overlap and maybe find open time slots to schedule new jobs in. I currently maintain a separate Outlook calendar to accomplish this, but it ...

Are there any tools that would allow me to make a backup of a remote SQL Server database and save it to my local computer's hard drive or my local computer's SQL Server 2000/2005 Express database?  I also want to be able to ...