I have a multidimensional application and have built an interface that exports the application data to a SQL Server 2005 data cube. My users...

Josh Sale

12-21-2006 04:25 AM
veysel

No more Query Analyzer, fine, but why did they remove keyword coloration? Is there a way to get it back? Paul

PJ6

12-20-2006 03:48 PM
St Wy

I am using SQL Server Management Studio. Whenever I open a .sql file, it does 2 annoying things: 1) prompts me to connect, yet again. 2) sets the...

Adam J. Schaff

12-19-2006 06:57 PM
Paul A. Mestemaker II [MSFT]

When I run config manager to configure network option of sql server, it only shows me SQL Server 2005 Network Configuration (32bit) and there is...

shariat@gmail.com

12-18-2006 05:34 PM
Erland Sommarskog

Hi - I'm trying to do manual log shipping from a SQL 2k Installation to a SQL 2k5 installation. The destination db in SQL 2k5 is at SQL2k...

Steve M

12-18-2006 05:29 PM
Erland Sommarskog

kzakoski (kzakoski (AT) discussions (DOT) microsoft.com) writes: That's one of these changes that looks like it was made by design - because else...

Erland Sommarskog

12-18-2006 05:17 PM
Erland Sommarskog

Yes, you are correct, SSMS is a 'client tool'. But as a client tool, it is designed to 'manage' SQL Server -hence the name 'Management Studio'. It...

Arnie Rowland

12-18-2006 03:22 PM
Paul A. Mestemaker II [MSFT]

Hi All, I have a log file of size 2 gb. I want to view last month transactions. How can I view this information. When I tryied to open this file,...

Bhaskara

12-18-2006 01:51 AM
Arnie Rowland

Hi all, I need to find an open source analyzer tool for SQL Profiler results. Is there anything out there that can do this? I did find...

Brian Madden

12-14-2006 03:43 PM
Jasper Smith

Is there any software that can analyze stored procedure performance and recommend solutions? Thanks, Dave

David

12-14-2006 05:46 AM
Andrew Gilbert

I've got our production Great Plains db's on SqlServer 2005. In management studio, I've defined my maintenance tasks to backup the db's (34 -...

Peter Lux

12-13-2006 11:48 PM
Charles Wang[MSFT]

I am using MS Access forms as a front end to a backend SQL Server Database. I am trying to use an ADO connection to return a Select Statement from...

ashleycvernon@gmail.com

12-12-2006 11:20 PM
Dave Patrick

Yes. Ultra-simple example: CREATE PROC myBackupProc AS BACKUP DATABASE master TO DISK = 'C:\master.bak' -- Tibor Karaszi, SQL Server...

Tibor Karaszi

12-12-2006 09:13 PM
Hari Prasad

Hi: I'm trying to add a field to a table by modifying it in Management Studio. I'm running SQLSMS locally on the server. When I try to save the...

geek-y-guy

12-12-2006 05:03 PM
Erland Sommarskog

....with continued support for SQL Server & other DBs. Altova is pleased to announce the availability of Version 2007 of its XML product line....

announce@altova.com

12-12-2006 09:40 AM
announce@altova.com

Where would i find and how would i install the sql server 2000 tools on a win2k3 standard server. My developer is stating he wants the...

mmark75

12-11-2006 07:00 PM
Arnie Rowland

We developed a DB for our customer using MS Access and upsized it to SQL Server. Our customer does daily back up of his DB and he asked me whether or...

markfine

12-11-2006 12:29 PM
markfine

Can any one help me in this.im working with java now.now i need to use all my reports which i have done in crystal report 9 in java ie i need to call...

samay

12-10-2006 08:57 PM
samay

Thanks John and Jasper. The SQL Manager looks good. Chris "John Bell" <jbellnewsposts (AT) hotmail (DOT) com> wrote

Chris Wood

12-08-2006 03:53 PM
Chris Wood

Hi All, Just thougt I'd post this here, I saw some people with this problem, but no solution. I had a problem in SQL server 2005 where any SSIS...

Rico Suave

12-07-2006 07:07 AM
Rico Suave

Hi all: I have MSCRM running in a VPC setup, so since I had 4 backup copies of the VHD files, I never backed up the DBs themselves. Now for some...

John

12-06-2006 09:08 PM
John

Don Sivitz (DonSivitz (AT) discussions (DOT) microsoft.com) writes: That's not an error that I've seen. Which method are you trying to use? Direct...

Erland Sommarskog

12-06-2006 05:11 PM
Erland Sommarskog

Jason Haley (JasonHaley (AT) discussions (DOT) microsoft.com) writes: Not that I know, but I would expect Mgmt Studio to be plain vanilla SqlClient...

Erland Sommarskog

12-06-2006 01:45 AM
Tibor Karaszi

On a "day to day" basis, the account I use to do work is not a member of the Local Administrators group. When I do an install, I'll either do a Run...

Al

12-05-2006 08:36 PM
Al

We have a 2 node Sql 2000 cluster running on Legato Cluster. We are planning to move it to MSCS 2 node Active/Passive Cluster. I am trying to migrate...

Irfan

12-05-2006 01:46 PM
Arnie Rowland

If SQL text is copied from MS-word into SQL Server Management Studio, invisible missing linefeeds may be copied in. This results in syntax...

W.D. Nijdam

12-04-2006 08:38 AM
W.D. Nijdam

Is there any way to get the old "script to new window as" instead of the new style that uses: EXEC dbo.sp_executesql @statement = N'ALTER...

KJ

12-03-2006 05:33 PM
Erland Sommarskog

I'm trying to restore a database that was backed up on another computer. The command I used was: RESTORE DATABASE iDB FROM DISK =...

Ron

12-03-2006 02:02 PM
Ron

Mattias (Mattias (AT) discussions (DOT) microsoft.com) writes: One possibility is that comparison is case-insensitive on the Access side, but you...

Mattias

12-03-2006 12:18 PM
Mattias

All, Is there any way to track what tables are being changed by an application. We have a third-party application that uses SQL server and for...

Jamal

12-01-2006 11:50 AM
valdez.delia@gmail.com

I set up 12 DB maintenance jobs on 3 separate DB's through the DB Maintenance Planner - each job has a daily time to run. All the jobs ran last...

WCM

12-01-2006 06:39 AM
WCM

Hello, this is what I'm trying to do: I have a database source2000 that I used to copy on the same sql2k (or other sql2k) server to dest2000 with...

Matt

12-01-2006 05:09 AM
Matt

I have a book that refers to the "SQL Server Assisted Editor" in management Studio. but when I right click on the Stored Procedure node or...

GaryDean

11-30-2006 09:10 PM
Peter Yang [MSFT]

I have a field of Image type in several tables in SQL Server 2000. Data was transferred from Access db awhile ago. In Access there is a way to see...

Esha

11-30-2006 12:37 PM
Tracy McKibben

Hello, Tangra, Inc. is pleased to announce the release of the new version of SQL Studio Data Compare - 2.5. This new version includes the following...

Plamen Ratchev

11-29-2006 04:25 PM
Plamen Ratchev

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

Martijn Tonies

11-29-2006 07:05 AM
Martijn Tonies

In my application installer, I'm planning on including SQL Server 2005 Express. Can I also include the SQL Server Management Studio Express (on the...

Troy Wolbrink

11-28-2006 08:44 PM
Troy Wolbrink

Hello all, I've installed the SSIS component and i'm trying to import data into an existing table. I can't find an option, via the import/export...

Art

11-28-2006 10:38 AM
Arnie Rowland

I frequently have to copy fairly large datasets from an SSMS result set into Excel. This works fine, except that it seems each time I do a...

Mike Caputo

11-28-2006 08:21 AM
Mike Caputo

Hi, used to have no problems with generating database scrips in version 2000, but now in version 2005, these scripts actually do not work! I mean...

Anatoly Kurilin

11-27-2006 10:33 PM
Paul A. Mestemaker II [MSFT]

RE: Sql Server 2000 I am using the EM DB Maintenance Planner to set up maintenance for several db's. In the dialog box I have checked 'yes' to...

WCM

11-27-2006 06:13 PM
WCM

Hi all, I am wondering if there is an option I can set in SSMS (2005) that will allow me to specify that I want to script object permissions when I...

JT

11-27-2006 04:45 PM
Erland Sommarskog

Hello, We have Microsoft SQL Server 2000 with Service Pack 3a installed. In one of our databases, we have a table REQ with one of the fields COMMENT...

newsqlserveruser

11-26-2006 09:21 PM
newsqlserveruser

Hi, please tell me where I can find Common Objects in SQL Server 2005.....that who appear in Query Analizer (SQL Server 2000) Common Objects: ...

Dio

11-26-2006 04:35 AM
Dio

We are having trouble tracking down some deadlocks and so I decided to use the new event Lock: Deadlock Graph Event and I set the Events...

Michael MacGregor

11-25-2006 08:37 PM
Kalen Delaney

And if so, any pros and cons ? I have heard that Spotlight can be an overkill on OLTP applications. Let me know..

Hassan

11-25-2006 03:33 PM
Satya SKJ

I realize that this seems odd, but I want to change the copy paste behavior in SSMS. Right now if you have no text selected in SSMS and do a...

wgbrown@gmail.com

11-23-2006 12:08 PM
wgbrown@gmail.com

Hi, I have looked for some time now and I cannot see how to install the Performance Tools in a pre installed SQL Server 20005. How do I go about this?

SteelMillDon

11-22-2006 03:33 AM
SteelMillDon

I am receiving an Event 208 when running our autmated backup in Enterprise Manager. The job use to run fine however possibly a change in...

Andrew Harlan

11-21-2006 07:47 PM
Sue Hoegemeier

And do you really recommend this as a "safe, efficient way to update data in SQL Server"?

gsengstock

11-21-2006 11:27 AM
Rick Byham, MS