Developer Newsgroups: SQL Server Tools

Best Practice Analyzer rule doesnt make sense

moondaddy - 19 Nov 2005 2:04 AM - 3 messages

I'm running the Best Practice Analyzer on a sql 2k server in an attempt to prepare it for 2005, and one of many rules that dont make sence is: Object contains an INSERT statement without explicit specification of target ...

Mobile Only? Why?

David Pendleton - 18 Nov 2005 8:25 PM - 9 messages

I've just finished installing the workstation tools from the SQL Server 2005 DVD (No database engine). I've also installed Visual Studio 2005, with just the VB option and the other standard stuff. When I start the Management Studio, connect to a server (doesn't matter what ...

Confusing, non-working db copy in 2005 - "specified subsystem"?

Richard K Bethell - 18 Nov 2005 6:24 PM - 4 messages

I really wanted to be enthusiastic about SQL Server 2005. I'm not off to a great start with that. I'm stymied by yet another wizard that is anything but. I tried to copy a database from a 2000 server to a 2005 server using the new ...

Database Schema copy

Dave H - 18 Nov 2005 4:18 PM - 4 messages

I want to a DB, and create an empty DB with the same schema. This was preety easy with Enterprise Manager, how can I do it with the new suite? ...

SQL Profiler: PASSWORD override available?

Chuck Hawkins - 18 Nov 2005 3:06 PM - 4 messages

I can appreciate the SQL Profiler exception of: -- 'password' was found in the text of this event. -- The text has been replaced with this comment for security reasons. However, when you are testing an application where you want to see the ...

Database Problem related Clusterd data

vibha - 18 Nov 2005 7:14 AM - 2 messages

Hello sir We have a very huge database its around 6 lakh records are being stored in it. records are not being a sorted order so we checked all ...

SQL Server Management Studio and Backup Log ... with no_truncate

Landry - 18 Nov 2005 3:01 AM - 1 message

Hi, When I put one database offline using Management Studio the option Backup in object explorer is disable. I execute the backup log ... with no_truncate in query window because the option is disable. In Enterprise Manager (SQL 2000) the option Backup still enable when ...

SP:StmtCompleted event

Alexey Rokhin - 16 Nov 2005 3:46 PM - 6 messages

How to get stored procedure's name in which statement was executed? ...

Copying data and indexes

Jaime Lucci - 16 Nov 2005 1:59 PM - 4 messages

Hi everyone! How can I do to copy the data and the indexes from an existing table on a database to a new table in another database? I've tried with select * into base1.table1 from base2.table2, but it only ...

ANN: AGS SQL Server 2005 Utilities

GregO - 16 Nov 2005 9:02 AM - 1 message

A & G Software would like to announce AGS SQL 2005 utilities. A set of must have utilities (SP and UDF) only for SQL 2005. Take advantage of the power of SQL 2005 SQL CLR integration right now. Just US$49.99 for 20+ utilities ...

index

varma viswanatha - 16 Nov 2005 5:42 AM - 3 messages

hi what was the important using indexes and how to create index and to view index how to implement index in my application thnak u varma *** Sent via Developersdex [link] *** ...

MMC error with Enterprise Manager

B. Mark McKinney - 15 Nov 2005 10:36 PM - 2 messages

When attempting to display a database's property window in Enterprise Manager an error happens with MMC. On a machine that also has SQL Server 2005 client tools installed Enterprise manager crashes. On other machines that do not have SQL Server 2005 client tools installed, MMC throws an error similar to ...

Where as the SQL Profiler gone

Aussie Rules - 15 Nov 2005 9:17 PM - 6 messages

Hi, I have installed the Sql2005 workgroup edition, and am looking to use the update profiler tool, which is a component I used a lot in 2000. The docs say its there, and shows how to start the Sql Profiler, but I do ...

Unable to Install SS Mgmt Serviice Express CTP

Robby - 15 Nov 2005 4:19 PM - 2 messages

Having successfully downloaded and installed C# Express and Web Dev Express (to include .NET Framework 2.0 and SQL Express 2005, I tried to download the SS Express Manager CTP. I successfully downloaded and installed on my Windows 2000 SP4 machine the ...

request/response style profiling

z f - 15 Nov 2005 1:33 PM - 5 messages

don't laugh, is there some utility that enables a request/response style profiling on SQL server. this is really needed. I mean not only seeing the SQL request like the SQL server profiler does, but seeing also the response in some way, lets say first 10 rows etc. ...

Mirroring SQL 2000 Data base files

Aasim Ashraf - 15 Nov 2005 12:51 PM - 4 messages

Hi, I want to confirm that is there any Microsoft or Third Part solution available from which we can Mirror SQL server Data base Folder to another server like mirror DB files from one machine to another. Waiting for your quick response. ...

debugging stored procedure with SSM studio?

laurent banon - 15 Nov 2005 8:36 AM - 3 messages

Hi, I know that it 's possible to debugg stored procedure with VS 2005 and is there a way to do it with SQL Server Management Studio? Thanks in adavance, Laurent ...

Where can I get Enterprise Manager?

Randy K - 14 Nov 2005 7:47 PM - 2 messages

Are enterprise manager and query analyzer available for download? I have a offsite developer who needs these tools but I hate sending the SQL Server 2000 CD and the keycode just to install the tools. ...

How to Capture data from server side trace to file?

msnews.microsoft.com - 14 Nov 2005 2:21 PM - 4 messages

Hi, I want to automate tracing for SQL server Profiler. I have written a set of stored procedures using the SQL Server in-built sp's for the very purpose. A trace is also being successfully created with trace id and a ...

sorting sql files by name

laurent banon - 14 Nov 2005 11:32 AM - 2 messages

Hi, I have created sql project through Sql server Management Studio. The sql files are sorted by the creation date of the script. Is it possible to sort them by name? Thanks in advance Laurent ...

Index Wizard Non-Cluster/Cluster Indexes

Joe K. - 13 Nov 2005 10:22 PM - 2 messages

I have primary key that is increasing integer value on a SQL Server 2000 database. Is it more efficient to make this a Cluster or Non-Cluster index? How many trips to the disk does it take to retreive data from a cluster or ...

SQL Express Import/Export

Tim Boyer - 13 Nov 2005 10:13 PM - 1 message

The document "SQL Server 2005 Features Comparison" (Published: November 7, 2005) [link] explicity says under the section "Integration and Interoperability" that the Express Edition supports "Import/Export" (the same as Workgroup, ...