I have been beating my head against the wall on this one, and am hoping
someone can point out what I am doing wrong here.
I am trying to set up a trace (using script) that will tracks all the
"RPC:Completed" events and give me some of the vital statistics like

I'm Running SQL 2005 and Microsoft SQL Server Management Studio
(9.00.3042.00) and experiencing strange behaviour when results from my
queries are displayed.
My regional settings are set to Icelandic (comma as decimal separator

When running profiler I am seeing strange duration times on some of
the processes.  I have seen large numbers before on a logout, but this
is on stored procedure exectution times.  It shows up about every 30
lines or so.  The value is in the trillions, so it can not be

Good Afternoon,
I have run the SQL Server Profiler to assist me in optimizing the perfomance
of one of my databases.  The Profilier was started and ran during our peak
time of our business day.  When I reviewed the location the trace log was

Run Microsoft SQL Server 2000 Express Edition  on OS server 2000
Standard.  Works fine; can't recall how I set it up.
Now newly installed Microsoft SQL Server 2005 Express Edition  on a
new server with OS Server 2003 Standard.  Need to enable TCP/IP so

We have an sql 2000 sp4 server that locks up whenever we try to run a
maintenance plan with only the option to Reorganize data and index pages
option check.  There are no event logs or entries in the activity logs for
what happens.  The server is just locks up and has to be ...

I have Management Studio installed on two different machines, one is
9.00.3042.00 (SP2) running against SQL Standard Edition SP2  and the other
is 9.00.1399.00 running against Enterprise RTM. The former, let's call it
MS2 (for being SP2), has a tab named Object Explorer Details ...

I have generated a trace by using SQL Profiler (SQL Server 2005).
I have launched the profiler in a test environment connecting to a remote
production db. I have used the T-SQLReplay model.
When I want to replay the trace in the test environment, this option is

We have a SQL 2005 DB which has a .ldf file of around 10GB...so it needs
shrinking!!
I've tried a shrink from the management tools but nothing actually happens.
This is probably due to the fact the DB is set as Full recovery mode. Without

Enterprise Manager will not return rows from tables in the database.  Returns
either a blank screen, or ms design tools catastrophic error depending on the
table.  Can connect and see all the tables just not the detail????
Thanks

Hi at all!
I need a tool to migrate my huge database (structure and data) from
MySql to MSSQL Express (after 4 years now i hate mysql).
I don't want to pay much ;)

I'm a newbie in the SQL world
I have to shrink the transaction Log of an SQL 2000 Database
So I googled around and found that I have to use the command
DBCC SHRINKFILE

I have a very simple result set displayed in a Grid in Microsoft SQL
Server Management Studio (2005) that I want to save as a CSV file. I
right click on the grid, select Save Results As... and save the file.
The file looks like this in a text editor:

I am running Windows Vista on a new Dell computer with both the Developer
and Expression versions of SQL Server 2005 installed and I am experiencing
the following problem:
1) Used modified downloaded "instnwnd.sql" script to create Northwind

Does anyone know of any tools which perform various design, best practice
checks on a database?
Something that looks at the schema, table definitions, internal procedures /
functions.