Developer Newsgroups: SQL Server Tools

SQL Server 2005 Lost Profiler Events

Cgal - 28 Oct 2006 3:33 PM - 3 messages

In SQL Server 2005, is it possible for the SQL Server profiler to miss events? This was the case in SQL Server 2000 in a heavily used environment. The fix was to do a server side trace. Does the same problem exist in SQL ...

Query Analyzer Colors?

beginthreadex - 26 Oct 2006 5:03 PM - 2 messages

I have my colors setup a certain way and it's very keen for me to do so. I have been asked to share my color schema with others but don't know how. Is there a hive/key in the registry that sets the colors? Then I could export ...

SQL Server 2005 Backup Devices

Loren Z - 25 Oct 2006 9:26 PM - 2 messages

One of my users was equiring about this. In SQL Server 2000 when you looked at the properties of a backup device, if you looked at the media contents the description header would be there and you could see the description you entered when you backed up the database. ...

Database filtering

Mario Vasquez - 25 Oct 2006 8:02 PM - 3 messages

Right now, when users connect to SSMS or Enterprise Manager, they can see every database in the server. I'd like to have them see only those databases which they have access to. At first, I thought I could use ...

Where are the options when producing a DDL script for all tables in Management Studio?

Michael MacGregor - 25 Oct 2006 8:01 PM - 2 messages

In Enterprise Manager it was possible to choose different options, such as whether to include indexes, triggers, etc., but I can't find where I can do this in Management Studio. I can generate a script with the CREATE TABLE ...

SQL Profiler and Network Address (Mac ADDRESS)

Josh - 25 Oct 2006 6:47 PM - 4 messages

Can profiler be setup to capture the clients MAC Address? If so how? ...

automate tool to change column type?

ChrisA - 25 Oct 2006 6:10 PM - 5 messages

SQL Server 2000/2005 Ent Mgr will allow you to jump into table designer and change a column type. 2005 will capture the script, which involves renaming the table, generating a new schema and then re-inserting the values. ...

Text Qualifier in a CSV file from results in SQL Server 2k5 Man. S

Greg Toronto - 25 Oct 2006 4:29 PM - 2 messages

When I save my results of a query in SQL Server 2k5 Management Studio, I can save it as a csv file. I have found where I can change the delimiter, but I can't find a place to put in a text qualifier. For example, I want the text ...

Possible problem using ss2k5's Import/Export & identities...

MrPCMan - 25 Oct 2006 2:56 AM - 1 message

I think there's a problem using the ss2k5 export tool. Let say for example you have two databases - both are identical in structure (actually second one is a restored backup of the first - just emptied out of all records using a ...

SQL Server SSMS Templates - share templates with others

timw86 - 24 Oct 2006 5:33 PM - 2 messages

I have started using the Templates Window and creating some new templates. These templates appear to be stored at the following : C:\Documents and Settings\<username>\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\Templates\Sql\* ...

SQL Profiler error message?

J - 23 Oct 2006 7:36 PM - 3 messages

Hello. Sorry if this isn't the appropriate place to ask this question but I was wondering if anyone could help shed some light on an error message that I've noticed popped up a couple of times in running SQL Profiler: ...

Cannot open or Create .dwProj files

Stefano Del Furia - 22 Oct 2006 7:14 PM - 1 message

Hi all, i have installed VC# Express, VS 2005 Pro and SQL Server Express. After this i have tried to install the SSE Toolkit for getting SQL Server Business Intelligence Development Studio. But after the installation i can cerate or open only Project about ...

SQLCMD - how to Suppress output

sdragolov - 22 Oct 2006 5:59 PM - 2 messages

Is it possible to suppress/turn-off the output that is returned from queries within a script when executing it with sqlcmd utility ?? I don't want to write the output to a file, just want to turn it off. ...

deploy management studio to users

vision - 22 Oct 2006 4:26 PM - 3 messages

is there a way to deploy only the workstation tools? Can I create an msi or sms package to install only the tools I need for users to have? Can I lock down the interface so all options are greyed out other than workstation tools? ...