So I used Profiler to obtain the Deadlock Graph and saved the trace both to an xml file and to a table. Rather than having to slog thru all...

Michael MacGregor

06-25-2009 11:15 AM
Jelle

I have SQl2005 enterprize version that was installed "analytical"?? Here is what I got: SQL Server 2005 --> Confiuration Tools --> SQL Server...

Dan DeCoursey

06-24-2009 02:10 PM
Aaron Bertrand [SQL Server MVP]

I have 64 bit sqlserver 2008 installed on a 64bit Window Server, and my problem is "there is no drivers listed in the 'ODBC/create New Data Source'...

NMahmoud

06-23-2009 06:54 PM
Hantour

Ignore that. Looking in the wrong database.

Michael MacGregor

06-22-2009 04:09 PM
Aaron Bertrand [SQL Server MVP]

Hi I have written some sql and have added a case when to remove nulls but it doesn't seem to be working is there a website where I can check the...

James Brown

06-19-2009 11:36 PM
Mike

Hi Dwaine, I am interested in this issue. Would you mind letting me know the result of the suggestions? If you need further assistance, feel free to...

Charles Wang [MSFT]

06-16-2009 03:24 AM
Charles Wang [MSFT]

Hi, I recently upgraded my workstation with SQL2005 to SP3. Since then it often happens that I get an "loading of the imagelist did not succeed."...

Adri

06-10-2009 04:37 AM
Adri

So why do you still need to use Enterprise Manager? They're not going to fix it...

Aaron Bertrand [SQL Server MVP]

06-09-2009 07:55 PM
Aaron Bertrand [SQL Server MVP]

Hello, I need to backup SQL server data bases. I plan to use Enterprise manager to plan regular backup. There is many databases in the database...

jn

06-09-2009 05:45 PM
William Vaughn MVP

Is there a way to generate the files so that they won't contain the "type"? For example, generating a stored procedure script will result...

Alex

06-09-2009 03:38 PM
Ray

The backup set holds a backup of a database other than the existing database *** Sent via Developersdex http://www.developersdex.com ***

shraddha dhuri

06-09-2009 04:00 AM
Tibor Karaszi

Good morning Erland, For both database and log file, I sent them to 10% file growth and unrestricted file growth. As I mentioned in my previous...

bass_player

06-08-2009 06:23 PM
Erland Sommarskog

Hi, I would like to know if it is possible to rename the tables that result after creating a diagram. I just tried it, and the diagram did not...

Carlos

06-07-2009 08:09 PM
Jelle

While trying to connect to Local or Remote Server on the network I received the following error, what could be happening? I need help... It's a SQL...

Futurist

05-26-2009 04:09 PM
Ekrem Önsoy

I'm trying to change the collation type of the master database to SQL_Latin1_General_CP1_CI_AS using RebuildM.exe . I don't see this collation in the...

Nick T

05-22-2009 04:32 AM
Erland Sommarskog

In SQL Server 2008 Management Studio object explorer you can expand the "tables" folder of a database to see the list of tables contained in...

Bill D

05-20-2009 07:36 PM
Bill D

I am not that new to Sql Server but I began using Sql Server Ent 2008 just a month or two ago. I recall that in 2005 Express there was that option....

AlexB

05-20-2009 06:07 PM
Erland Sommarskog

Hi, I have a very big sql script that I can not opne with Mangement Studio due to the size. What other tool can I use to execute this script? All it...

Pingx

05-18-2009 03:33 AM
Manpreet Singh

Is there somewhere I can download just the client tools install for 2005?

Mr.Magic

05-18-2009 03:26 AM
Manpreet Singh

in SQL 2005 I could use right mouse script select (or other statements) to cliboard In 2008 it shows the wait cursor but nothing goes to the...

Ofer Gal

05-14-2009 05:55 PM
Erland Sommarskog

I'm trying to create a simple Add-On for SQL Server 2008; it is simply going to pass a parameter from SQL 2008 to a console application. Although...

CJM

05-14-2009 11:13 AM
Aaron Bertrand [SQL Server MVP]

Hello Group, We were running SQL2000 and upgraded to SQL2005. After backing up our databases to a remote HD and restoring them onto SQL2005 I can no...

Rick

05-11-2009 05:59 PM
Erland Sommarskog

Hello All, We got a new product we've recently launched, it's a query tool and its still in beta, and we're giving it for free to...

Itamar, Nobhill Software

05-08-2009 02:20 PM
Itamar, Nobhill Software

Is there a way to make SSMS default to US-ASCII when saving a .sql file? I have searched the options. Is that connected to the current codepage of...

Dan Holmes

05-07-2009 06:43 PM
Erland Sommarskog

SQL Image Viewer enables you to retrieve, view, convert and export images and binary data stored in Firebird, MySQL, Oracle, SQLite, SQL Server,...

Ray Mond

05-07-2009 11:28 AM
Ray Mond

Using Management Studio with SQL 2005 or 2008, does deleting a table have the same effect as dropping a table?

Jeffery Rehm

05-07-2009 10:23 AM
Jeffery Rehm

SQL Maestro Group is happy to announce the release of MS SQL Maestro 9.4, a complete GUI tool for SQL Server 7/2000/2005/2008 administration...

SQL Maestro Team

05-07-2009 03:43 AM
SQL Maestro Team

SQL Server 2008 Management Studio Server type When registering a server from Object Explorer, select the type of server to connect to: Database...

GABloom_SQL_BI

05-04-2009 01:59 PM
GABloom_SQL_BI

I would be very interested in hearing about any free or very low cost utilities that anyone would recommend for helping to make sure...

mat

05-04-2009 03:41 AM
Amit

Hi all, I just created a database, and immediately wanted to create a diagram for it. However, when I tried it, I just got a box titled add a table,...

Carlos

05-01-2009 08:32 PM
Aaron Bertrand [SQL Server MVP]

Unfortunately I can't help you fix "something to that effect"... If you try it again and list the *exact* error message (as well as which commands...

jpBless

05-01-2009 06:41 PM
jpBless

Once you sort out your install issues, you can do a backup and restore. Be sure to check out sp_change_users_login in the...

Tom Moreau

05-01-2009 08:06 AM
Aaron Bertrand [SQL Server MVP]

I want to put a blank value into a datetime field in sql server 2005. However I am getting the date of '1/2/1900'. In the following statement, I...

douglas

05-01-2009 02:31 AM
Tom Cooper

I am trying to figure out how to detect issues with queries via SQL Server Profiler and trace files. Because of the way we utilize JDBC with...

Mark Price

04-30-2009 06:01 PM
Erland Sommarskog

I've started the system data collection sets, and they've been active for a few weeks now. But when I look into the table...

Franky

04-27-2009 10:58 PM
Shirley Wang [MSFT\SQL]

I am trying to run the Tuning profile in SQL Server Profiler 2008 against an SQL Server 2000 database, but I get the following error message when I...

tomf84

04-25-2009 06:02 PM
Erland Sommarskog

I am unable to start SQL Server 2005 integration services on my database server. Listed below is the error I received when trying to start SQL...

Joe K.

04-16-2009 09:07 PM
Paul Shapiro

Devart Releases dbForge Schema Compare for SQL Server! Devart, the leading provider of solutions for connecting software with data and database...

Devart

04-16-2009 03:15 AM
Devart

Dear ladies and gentlemen, Upscene Productions is happy to announce the next version of their test data generator tool: "Advanced Data Generator 2"...

Martijn Tonies

04-15-2009 08:50 AM
Martijn Tonies

Hello All, We got a new product we've recently launched, it's a query tool and its still in beta, and we're giving it for free to...

Itamar, Nobhill Software

04-14-2009 02:54 PM
Itamar, Nobhill Software

I'm looking for a tool that will compile historical usage information for a specific SQL Server 2000 database down to the column-level. This is...

Hari Seldon

04-14-2009 02:46 PM
Itamar

I have three SQL server instances on my local box: (local) = SQL Server 2000 (local)\SQL2005 = Developer Edition SQL Server 2005 (local)\SQLExpress...

TBQ

04-13-2009 04:47 PM
TBQ

dbForge Data Compare for SQL Server is a new tool for data comparison and synchronization in SQL Server databases and walks you through...

Devart

04-13-2009 03:31 AM
Devart

When installing SQLServer2005SP2-KB921896-x86-ENU.exe (local on the machine) under both USER or SYSTEM context I get 1721 error. all the other...

SS

04-10-2009 03:56 PM
Aaron Bertrand [SQL Server MVP]

Vista Home Premium, Visual Studio 2008 standard, SQL Server 2005 developer edition. I installed SQL server and the business intelligence dev studio...

Patrick

04-10-2009 08:37 AM
Patrick

For anyone who has ever used Visual Studio as well, the management studio interface is very similar to what VS has had for a while. One difference...

Charlie Brown

04-09-2009 04:42 PM
William Vaughn \(MVP\)

When running scripting from MSM for tables; the defaults for tables are being saved in seperate files from the main file for that table. This is...

Tom

04-08-2009 07:00 PM
Tom

Hello Everyone, Running on Windows 2000 Advanced server service pack 4 I am attempting to simulate SQL IO Patterns using SQLIOSim and...

FredG

04-04-2009 04:17 PM
FredG

At one time I was able to stop the "Connect to Server" prompt from displaying when starting Management Studio. I installed a new version and now I...

sfsd

04-02-2009 01:43 PM
Alan Brewer [MSFT]

Using SSMS, in the Object Explorer, when I drill down to database D1 and right click on table T1 and choose "Select Top x Rows", the query window...

Glen

03-30-2009 05:39 PM
Glen