SQL Server Tools

Hello, Tangra, Inc. is happy to announce new versions of our SQL Server tools: SQL Studio Data Compare 2006 - an advanced data comparison utility for Microsoft SQL Server databases. New features include: -Command line interface -Multiple server locations -Define custom primary keys ...

Hello all, Every time I open Enterprise Manager and expand SQL Server Group, my servers show up with the "status" circle blank.  I can leave it open all day long and it will never check/"poll"/what-have-you the server to see what the status is.  It will only check when I ...

Hi All: I'm missing a basic concept in SQL2005 Security. I have a dB on a staging server set up like: dBname: someDBname login: someDBname --mapped as dbo where the database and the dbo login have the same name ...

Hi, on sql server 2000 ... apart from going to the execution plan, is there a way to identify queries that are doing table scans ? thanks ...

In the Notifications section of SQL Server Agent > Jobs, only one Net send operator can be selected.  Setting up an operator with multiple semicolon delimited computer names as recommended in the following thread did not work: [link] ...

Hi, We have quite a few SQL 2000 servers and 1 2005 Server can I use the Enterprise Manager from 2005 to manage the 2000 servers? Thanks ...

I'm running SQL 2000 SP4 on a Win2003 server... I have a DB that is about 30GB in size. I notice every month or so I need to do a backup of the DB and transaction logs through Enterprise Manager. After ...

Hi I am trying to load the 30 records into the database table. I have created one Format File and one .sql file to load the data. I observed one problem during loading the data into table, if there is any problem in the first ...

Does anyone know of a way to identify views from profiler ? I have poorly performing views on a large system and no direct way to point back to one particular one Thanks ...

Hi, I have a table with 22 million records in a sql 7 server. I want  to copy it to a SQL 2005 database. What is the most quickest tool to use (BCP, Bulk insert, SSIS) and how. Thanks in advance ...

Hi all I need to generate a load of test data for an upcoming project and came across the DBGen tool in the SQl 2000 resource kit. I'm wondering if there's a new version in the 2005 resource kit? If not, will the 2000 version work ok ...

Under what conditions is 'Change Type' available? I used to use it a lot with EM2000. If I choose 'Open Table' in Object Explorer then 'Change Type' dropdown is grayed out. ...