When I start SQL Server Profiler, it says trace is starting at the bottom, and may return rows for a few seconds, but then it stops saying "Trace...

Larry

09-28-2009 05:40 PM
Erland Sommarskog

When I open a table in SQL Management Studio I get a message stating "Object Reference not set to an instance of an object. (SQLEditors)" I have...

C

09-23-2009 09:10 AM
Russell Fields

Good day, My product installs SQL Server 2005 as a named instance. One of my clients other software packages needs to install to the default...

Gina Marano

09-18-2009 01:37 PM
Gina Marano

Does detailed steps (job) activities for SQL Agent jobs get logged step by step in the SQL Profiler Trace output (or file if specified)? I did see an...

Zee-SS-DBA

09-15-2009 02:28 PM
Ekrem Önsoy

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

Ray Mond

09-15-2009 01:03 AM
Ray Mond

Hello. I'm using SQL 2008. I am at my wit's end. All I'm trying to do is import data into a SQL table. No matter what data type I try (varchar,...

Craig

09-14-2009 05:39 PM
Erland Sommarskog

Does someone know a tool similar to fxcop for SQL ? i.e. a tool that could scan SQL code (stored procedures/functions + data model) to find possible...

Nik

09-14-2009 05:02 AM
Nik

I am using SQL server 2005 Managment Studio connecting to a SQL 2000 server. The OPENROWSET command will not work. When I use SQL Query Analyzer,...

FredF

09-11-2009 04:58 PM
Erland Sommarskog

Based on your comments, when we go Windows 7 we should have SQL2008 Client tools even though we will most probably be running SQL2005 SP2 and...

Andy P

09-08-2009 10:21 AM
Russell Fields

Hi All My first post on this list. I am using the Import and Export Data (32-bit) to made a import from Firebird, all seems work fine but when i...

//---- Kelsie.Z.Marshall ----//

09-07-2009 08:56 PM
//---- Kelsie.Z.Marshall ----//

I am in SQL 2005 Management Studio under account that is an administrator on the Windows 2003 R2 server. I can't see my local H: & T: drives when I...

elpepe

09-05-2009 08:33 AM
elpepe

We need to get some monitoring tools in house and was wondering what you use at your organisation ? We were thinking either the tool from Quest or...

Hassan

09-04-2009 05:14 AM
Itamar

Thanks to both of you. I did use the detach method and it worked fine. Thanks again :) "Erland Sommarskog" wrote:

Trebor Nadroir

09-01-2009 09:16 AM
Trebor Nadroir

Hello: We have implemented a 64-bit SQL 2005 Server Standard. We need to install the client tools on three 32-bit workstations. To do so, would we...

childofthe1980s

08-27-2009 07:33 PM
geeta

I am working with SQL 2005 Developer edition and love everything. We are getting ready to replace the SQL 2000 server with SQL 2005. Will it...

Rich Lawson

08-27-2009 05:21 PM
Erland Sommarskog

I installed Management Studio on a desktop and I'm connecting through a non standard port to a sql 2005 db engine on another network, through a...

joker197cinque

08-26-2009 09:09 AM
Aaron Bertrand

Running SQL Server 2008. Just wanting to know if there is a way to run a project/solution from the command line. I know I could put some of the...

Hoardling1 via SQLMonster.com

08-25-2009 01:23 PM
Hoardling1 via SQLMonster.com

Hi - Initially I got an Registered Server Exception when I opened the SQL Server amangement studio, but after I installed SP1 for SQL server 2008...

Deepak Ramakumar

08-24-2009 05:35 AM
Charles Wang [MSFT]

Hello, I am looking for a tool that builds ERDs and Database diagrams and from these generate the database scripts to create the schema. This is the...

devdewboy

08-20-2009 06:01 PM
Michael Ross

Could someone recommend a free query tool? thanks

tulip

08-19-2009 11:10 AM
Jonathan Sion

After installing SQL Server Management Studio 2008 I get the following error alert whenever I right click on a table to get the table menu: EXECUTE...

sikander

08-19-2009 02:38 AM
sikander

Hi, Does someone know if there is possible to create a widget for windows sidebar in visual studio 2008? Do I have to install a sdk or something to...

Rajoo Sharma

08-13-2009 02:39 PM
Noldus

I am in the process of upgrading my Report Server projects from 2005 to 2008. These reports use an Analysis Services data source and have queries...

Mitch McBride

08-12-2009 05:24 PM
Mitch McBride

I am trying to create diagrams in Visio that display tables in our SQL database. But our tables have so many fields, they don't fit in the drawing. ...

Ed

08-11-2009 10:20 AM
Geoff N. Hiten

Hi - I've just upgraded my dev machine from XP to Windows 7 but am hitting a fairly major problem running SSMS (or connecting to SQL Server via...

Mark

08-08-2009 09:22 AM
Aaron Bertrand [SQL Server MVP]

In SQL Server 2000 Enterprise Manager I used to use the "Create Stored Procedure Wizard" all the time to create INSERT and UPDATE stored procedures. ...

Chris

08-06-2009 10:38 AM
Chris

I have a table with a single index. (Unique on primary key, clustered) Each morning the index needs to be rebuilt for some reason. In my...

Herb

08-05-2009 09:56 PM
Mark Han[MSFT]

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

Ray Mond

08-05-2009 11:10 AM
Ray Mond

using sql server 2k, I have been importing csv files reliably for months but have now been sent a new csv file which contains a quoted field...

Dash39

08-04-2009 05:19 PM
Erland Sommarskog

http://www.nanometer.ru/users/microsoft-lsd-tv.html doctor-lsd-tv (AT) yandex (DOT) com tel.8_9195265461 patent Japan

doctor-lsd-tv Google

08-03-2009 03:01 AM
doctor-lsd-tv Google

Hi, I have 20-30 SQL database files. How can I to export the data into Excel files automatically or by batch (using macros)? Any built-in command in...

Simon Kwong

08-02-2009 06:25 PM
Erland Sommarskog

Hello: I successfully installed the SQL 2005 client tools using the 32-bit CD #2. It was not without a few surprises, however, and I am hoping that...

childofthe1980s

08-01-2009 04:58 PM
Erland Sommarskog

Via sql , I created a unique constraint on my table , but in SSMS it doesn't show up in the Constraints list but rather in the Indexes list. I know...

John A Grandy

07-31-2009 06:22 PM
Erland Sommarskog

I am migrating from one SQL-based help desk system to a competing one. I have a few hundred tickets to migrate to the new system. What is the proper...

bnick22

07-29-2009 11:29 AM
Lucas Kartawidjaja

SQL Scripter is an easy to use data export, import, scripting and reporting utility for Microsoft SQL Server (MSSQL). - Generate T-SQL Data Scripts...

Thomas

07-25-2009 09:24 AM
Thomas

Hi, I just found out from performance dashboard that there is an active trace running. I have no idea when it is started. Is there a way to stop the...

Pingx

07-16-2009 07:38 AM
Dan Guzman

Hi at a few months ago we made a Small business install and a few days ago we start getting a message from management studio evaluation "period has...

Gil Cartaxeiro

07-14-2009 07:39 PM
Mitchell Hubble

I have installed on a user the SQL Server Management Studio Express console and they have full control , at least I think so to the ...

scuba19

07-09-2009 06:49 PM
scuba19

I have it installed. How do I collect data and look at the report? Thanks. Pingx

Pingx

07-09-2009 06:00 PM
Ekrem Önsoy

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

Ray Mond

07-06-2009 10:35 PM
Ray Mond

SQL Server 2005 Upgrade Advisor crashes evrytime I run it. I've found some details on the web that this is caused by the client having a .Net...

Brent

07-06-2009 12:58 PM
Glenn

Hi, Earlier today I was trying to install what I thought was SQL2005 Standard 64-bit but proved to be Enterprise Edition. I uninstalled but now I...

Chris Wood

07-03-2009 09:56 PM
Andrew J. Kelly

Frère Jacques, frère Jacques, Dormez-vous? Dormez-vous? Sonnez les matines! Sonnez les matines! Ding, dang, dong. Ding, dang, dong. "apartamento 3...

Jeff

07-02-2009 01:16 PM
Jeff

I understand about the same spid but I am not sure about: <how many CPU milliseconds are consumed by that spid in that time period What is 'that time...

Mark Goldin

07-02-2009 02:20 AM
Linchi Shea

I am getting an error in Microsoft SQL Server Management Studio when designing a View on a Table. The table definition is: CREATE TABLE .( ...

MichaelQuinlan

07-01-2009 06:23 PM
Erland Sommarskog

How to create a single bar chart by using the report builder 2.0??...IM new to report builder2.0 , so i would like to know more about report builder...

Eunice

06-30-2009 04:50 AM
Eunice via SQLMonster.com

I have a script that populates some tables in a database. The script was generated from Management Studio and includes some fields that are...

dj7934

06-29-2009 05:20 PM
Erland Sommarskog

Erland, Thanks for the code and detail explanations. Unfortunately, I don't get a chance to see your post until today. Unless I am missing...

Accesshelp

06-26-2009 05:59 PM
Erland Sommarskog

I have a txt file I have to bcp in. The file contains fixed-position columns of data but there is white-space in certain positions which I have to...

Snake

06-26-2009 05:56 PM
Erland Sommarskog

Hi, sql2005 I used the Maintenance Plan wizard to set up a daily backup plan to run after hours. So I now have a plan and sql server agent job;...

Jonathan

06-25-2009 10:20 PM
Jeffrey Williams