I am comparing tools for synchronizing databases. The best I have found so far is SQL compare from Red-Gate. Does the community have any suggestion...

Online User

10-16-2008 10:48 AM
Online User

Environment: SQL Server Editions: SQL Server 2000, SP 4 SQL Server 2005, SP 2 with Cummulations Hotfix (kb918222) O.S. Windows 2003 Server R2, SP...

mj

10-15-2008 04:27 PM
Geoff N. Hiten

This problem has just started happening and I'm looking for clues ... anything to help me troubleshoot. When I allow the mouse pointer to hover over...

Timo

10-15-2008 01:59 PM
Aaron Bertrand [SQL Server MVP]

In article <MPG.23542acd6710ed98972d (AT) msnews (DOT) microsoft.com>, mat (AT) notarealdotcom (DOT) adr says...

mat

10-15-2008 10:16 AM
Ekrem Önsoy

From ssms 2005, when I select the New query all I get is a blank sql window. How do I open in the query grid window? ALso why is the query designer...

Jim Jacoby

10-14-2008 01:12 PM
Aaron Bertrand [SQL Server MVP]

I've got an Access application with a SQL Server back end. SQL Server db is about 4 gig. Transaction log is about 10 gig. It just seems to keep...

Always OpenTo Suggestions

10-14-2008 01:01 PM
Roy Harvey (SQL Server MVP)

I need SQL Server Management Studio (32 bit) on my workstation. If I download the evaluation version of SQL 2005 and just install the tolls, will...

Kelvin

10-10-2008 06:05 PM
Erland Sommarskog

I was working, running queries in Query Analyzer on my PC desktop (running XP Pro) against a SQL2K instance on a server on our LAN. When all of a...

Timo

10-10-2008 01:36 PM
timo

In SSMS, if I open a query file a second time it just flips me back to the tab with the first time I opened it - even if I'm trying to run the...

MichaelH

10-10-2008 12:25 PM
MichaelH

When installing SQL Server 2008 SSMS fails to install with an error that the Handle is Invalid. This caused me to uninstall and reinstall 3...

SteveKing

10-09-2008 05:51 PM
SteveKing

Hi gurus, Does somebody knows tool(s) for subject ? Regards, Eugene

Eugene Korolkov

10-09-2008 05:49 PM
Erland Sommarskog

How do I uninstall an instance of SQL Server 2005 from the command prompt unattended? The following command line brings up all instance names and...

Rick

10-09-2008 03:52 PM
Rick

I have to migrate an IBM iSeries AS400 database to SS2005/8. I tried to use Erwin 7.1 tool to Reverse Engineering the iSeries database into a model....

Snake

10-09-2008 02:06 PM
Roy Harvey (SQL Server MVP)

I find it extremely bizarre that I cannot resize this window: http://www.shackpics.com/files/sqlmanagement_x7qp9wev6dklupp88g19.png Why would they...

sikander

10-09-2008 08:03 AM
Roy Harvey (SQL Server MVP)

I am thinking about creating a custom RDL for running in SQL 2005 Dashboard. Does anyone know if there are any pre-built ones out there for...

Dragon

10-09-2008 08:00 AM
Dragon

What is not functioning corretly. I set up a job to delete old backup files, so I dont need to do it manually. I execute the job to test it. The job...

DVandov

10-09-2008 04:29 AM
Ekrem Önsoy

Reading this document: http://msdn.microsoft.com/en-us/library/ms143729.aspx about changes in SQL Server 2008, I noticed a comment that Solution...

SimonDev

10-08-2008 11:28 PM
SimonDev

Hello, i am using (well: want to use) SSMS Express 2008 to access our database on the server of our hoster. Previously i did that with the...

Ralf Kaiser

10-08-2008 03:11 AM
Erland Sommarskog

This is a repost in hope Microsoft will notice the alias and maybe answer this since others have mixed opinions. SQL Server 2005 Database Engine...

Mike

10-07-2008 05:37 AM
Charles Wang [MSFT]

I've started to use the 2008 management studio and intellisense works correctly against a 2008 database. When I try to use a query against a 2005...

Denny

10-07-2008 01:13 AM
Mark Han[MSFT]

Thanks. It's good to know that the "higher ups" know about the problem. Hope there is a fix for this and other annoyances soon... It can get quite...

Mark H. Shin

09-30-2008 05:05 PM
Bob

The thing with the MVP logo methinks is because two pretty diverse systems are integrated. We have the NNTP protocol which we use a newsreader to...

TomT

09-30-2008 11:36 AM
Aaron Bertrand [SQL Server MVP]

BOL provides pretty much no information about what the value contained in the ObjectID2 column for a Lock Acquired event actually refers to....

Michael MacGregor

09-29-2008 11:07 PM
Michael MacGregor

Hello: I noticed a difference between the use of SQL Tools for SQL 2000 and SQL Management Studio for SQL 2005. If you use SQL 2000 Tools on a...

SQL Programmer

09-28-2008 04:58 PM
Roy Harvey (SQL Server MVP)

SQL Server 2005 Developer Edition for all boxes. I have a small database on a W03S x64 box. I perform a backup using SSMS. No errors. I copy the...

John A Grandy

09-27-2008 04:54 PM
Erland Sommarskog

Hi, I did a tuning analysis that showed a estimated improvments on 59%. However after applying the workload the query is is dead slow. Is it possible...

Lasse

09-26-2008 02:25 PM
Aaron Bertrand [SQL Server MVP]

I am not sure what you call it, but I am looking for the stored procedure that will list out all of the tables in a particular database possibly in...

Larry

09-26-2008 11:38 AM
Larry

Thanks for your reply. During the analysis of performance monitor counters inside Profiler for some of them I have noticed a selected value equals to...

Pasquale

09-26-2008 04:24 AM
Pasquale

I am running MS SQL 2000. There are some agent jobs that I can not delete - Error 14274: Cannot add, update or delete a job that originated from an...

Tom Parke

09-25-2008 07:58 PM
Lee

Can you use the sqlcmd tool that shipped with SQL 2005 to run scripts on a SQL 2008 database? -- DB

DB

09-25-2008 05:57 PM
Erland Sommarskog

What is latest version of Visio available that can be used with MS SQL Server 2008 database. It should support functionality like 1. Compare Visio...

Santaji

09-25-2008 04:39 AM
Gerald Aichholzer

I'm trying to copy data from a local database to a remote database via tasks->Import Data. However the execution fails with the message: The...

invalid@stuff.invalid

09-24-2008 11:57 PM
Mohit K. Gupta

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) ADDITIONAL INFORMATION: An exception occurred while executing a...

Alberto

09-24-2008 06:31 PM
Erland Sommarskog

Are there any plans to release Analysis Server Management Objects 2008 (AMO) in a separate (free) download? SMO 2008 is released in a feature pack...

Jesse Hersch

09-18-2008 11:53 PM
Jesse Hersch

Hi, I've recently installed the SQL 2008 tools so I can begin creating SSIS 2008 packages. However I've found that I now have an issue with my...

Keith F.

09-18-2008 03:50 PM
Keith F.

Looking for a tool that I can compare like db's on different servers. I.E. I want to compare and see differences in the data on our dev server versus...

Keith

09-17-2008 09:53 PM
Dariusz Dziewialtowski

I want to export SQL data using BCP.EXE and for normal operation everything's fine. The default record delimiter of "\n" gets mapped to 0x0D, 0x0A...

Thomas W. Brown

09-16-2008 06:12 PM
Thomas W. Brown

If I were to read the bcp out file, and I had the 8 bytes of the datetime field in the file, how would I convert those 8 bytes into a...

Harolds

09-16-2008 11:56 AM
Harolds

Sql Server 2005 : Can SSMS be reliably used to relocate data ( .mdf ) and log ( .ldf ) files ?

John A Grandy

09-15-2008 05:46 PM
Erland Sommarskog

hi i un-installed all sql express 2005 components and the databse engine from the control panel and then installed sql 2008 express, then i...

Pure Heart

09-12-2008 05:11 PM
Erland Sommarskog

I'm MSDN subriscriber and i can't find in download of this CD (SQLSERVER 2000 RESOURCE KIT ) i need the log shipping tools where can i find ?

Dolfo

09-12-2008 03:40 AM
Dolfo

In Sql Server Management Studio when I right click on the Service Broker and select New Service Broker Application the code that it generates...

newscorrespondent@charter.net

09-11-2008 08:14 AM
Dan Guzman

Ctrl-Shift-M does not appear to work in this version (for templates), is this a bug? Thanks

TomT

09-10-2008 11:56 PM
Mark Han[MSFT]

Why does SSMS 2008 force ALL new server registrations under "Local Server Group"? In 2005, I could create folders (almost) arbitrarly in the folder...

Mark H. Shin

09-09-2008 02:25 AM
Tibor Karaszi

Hi, I noticed strange problem with sql server profiler. When I filter trace by searching events which contain some word in text data column (i.e....

Pedja

09-08-2008 08:19 PM
Andrew J. Kelly

HI, I keep getting a "Class Not Registered" error when I try and use the Import Export wizard. I've reinstalled several times but I'm still having...

todd.lowney@bankofamerica.com

09-08-2008 12:50 PM
Aaron Bertrand [SQL Server MVP]

I setup a mirroring database, have principal (host A), mirroring (host B), withness (host C) i create a user account and login account "usera" can...

ken

09-02-2008 10:15 PM
ken

Hi All: I created a trace file, and when I ran tuning advisor many of the queries of interest couldn't be optimized because the user didn't have...

geekyguy

09-02-2008 04:07 PM
geekyguy

I am using SQL Server Express 2005 on a Windows Server 2008 server. I noticed that the included Windows Server Backup fails if the SQL Server VSS...

Dominick

08-31-2008 04:45 PM
Aaron Bertrand [SQL Server MVP]

I'm using SSMS with SQL 2005 SP2. I've been trying to create a script using the "Generate Script" wizard that only has Drop Index and Create...

kmoskal@newsgroups.nospam

08-29-2008 06:40 PM
Erland Sommarskog