Hello: On an XP workstation, I would like to install the Client Tools for SQL 2005 Standard, so that the end user can utilize SQL Management Studio...

SQL Programmer

01-15-2010 07:56 PM
Jeffrey Williams

Is There a Microsoft product for create an automatic "graphical report" by a source code SQL, to rectify query and to view the fields and tables used...

Marco R.

01-13-2010 04:22 PM
Erland Sommarskog

I have multiple SQL servers and I have Jobs that run everyday to do various tasks. Is there a 3rd party app or something that would collect the...

Barrycuda

01-13-2010 03:51 PM
Aaron Bertrand

When you say you want to give them "rights to access/manage the sqlserver", what is it you want them to be able to do? -- Rick Byham, MSFT (Implies...

ghurty

01-08-2010 11:05 AM
Rick Byham, MSFT

Hello, I have a sql 2000 table that has a column with values such as First Name - George Last Name - Smith Room number - 229 Chart Location -...

John Smith

01-06-2010 10:42 AM
Erland Sommarskog

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

01-06-2010 04:37 AM
Martijn Tonies

Hi, I've released the new CTP(2) of SQL Stripes 2010. It has numerous new features and is completely free for 30 days (fully functional, no...

Adi@SqlStripes

01-05-2010 03:11 AM
Adi@SqlStripes

Hi all, I have developed a database comparison program, Table Diff, and I would like to ask for feedback, if you have time. Table Diff runs on...

giammarco@volpet.com

01-04-2010 05:06 PM
giammarco@volpet.com

Howdy Ya’ll! It seems as the article (http://support.microsoft.com/kb/271509) and the scripts were modified in the last few years. Somewhere along...

Olegas

12-23-2009 01:04 PM
Olegas

The intellisense feature in SSMS 2008 is great but alot of my old stored procedure code uses local variables that start with 2 @ signs, e.g....

David Morse

12-20-2009 11:42 PM
Aaron Bertrand

The 2008 SQL server can see the 2000 on a different machine. - The import/export wizard no longer has 'Copy all objects and data' option. If I...

Jan Doggen

12-14-2009 05:34 PM
Erland Sommarskog

If I've got a SQL 2005 database that I want to import to SQL 2008, but never upgrade it to a 2008 database, can it be unmounted and re-imported back...

Andy

12-14-2009 12:09 PM
Rick Byham, MSFT

Hello, I am having a problem relattin go BCP and SQLServer 2005, which is reported as a bug to Microsoft, check link...

Luis Lima

12-14-2009 04:53 AM
Luis Lima

I have a database that is 400gb in size and is in full recovery mode. We perform a full backup nightly and apply this backup to the reporting...

Thom

12-11-2009 11:53 AM
Russell Fields

Hi All, As a dba, I spend a lot of of time opening .sql files. I've just moved from XP to windows 7.0 and am suffering with a small change in...

Mark Hickin

12-09-2009 09:48 PM
Jeffrey Williams

Hi friends need help for the following I m using SQL 2000 What I want to do is I want to create a single Text File containg data from 2 tables using...

chintu4uin@gmail.com

12-08-2009 02:56 AM
Hugo Kornelis

I'm using SSMS Express to feel my way around SQL Server 2005 Express as a beginning admin. I'm using Microsoft Press's "SQL Server...

BruceD

12-06-2009 09:03 PM
BruceD

When opening the SQL Server Migration Assistant for Oracle SQL Server instance for conversion it gives me the following error: "SSMA could...

Todd_Plettell

12-03-2009 11:02 AM
D Williams

I would like to upgrade3 my development machine to Windows 7. I moved all my development tools without real problems. Only SQL Server 2000 is not...

vovan

11-26-2009 09:35 PM
vovan

the real problem is as shown in the message is truncated, it means that the value you are trying to insert is greater than the length of the field...

Roger Quispe Del Castillo

11-26-2009 05:56 PM
Roger Quispe Del Castillo

When I select my external tool SSMS prompts me (through all unsave tabs) to save each unsaved tab. How do I get SSMS to just start my exe without...

Harolds

11-25-2009 06:07 PM
Harolds

Hi all, Is there a formula into which values such as server specs, table and row sizes, and index type can be plugged to compute the time for a...

Sean Clayton

11-25-2009 03:14 PM
Alen Teplitsky

HI, I am using Windows Server 2003 English version, and I also install SQL Server 2005 English version. After I migrated Databse to SQL, all clients...

Michael Cheung

11-18-2009 01:42 PM
Linchi Shea

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on...

Mia

11-18-2009 10:29 AM
Mia

A user has SQL 2005 Express installed on her machine. She uses it for an application installed locally. She wants to be able to install the...

Charles Allen

11-16-2009 04:44 PM
Sylvain Lafontaine

I just upgraded to Windows 7 64-bit from XP 32-bit. I'm using SQL Server 2008 Enterprise. When I try to restore a database in SSMS, and I check...

Ed

11-15-2009 12:29 PM
Aaron Bertrand

SQL Stripes has a new beta version (CTP actually) which came out after quite a long wait (guess it was worth it!) For guided tour video and free...

Docco

11-15-2009 08:46 AM
Docco

Thanks chris

Chris Kloss

11-14-2009 03:33 PM
Kalen Delaney

How can I display SSMS query results using current Regional settings? In other words, what happened to Query Analyzer's option: "Tools > Options >...

vsiat

11-11-2009 05:23 PM
Erland Sommarskog

I reviewed the other posts about backups and don't see anything like this. I have a Vista Home Premium laptop on which I run SQL Server 2005...

hedera

11-11-2009 05:22 PM
Erland Sommarskog

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx You can read all about it on the above web...

Itamar, Nobhill Software

11-10-2009 04:17 AM
Itamar, Nobhill Software

Hi All, We've written a number of (I think!) handy tools over the past few months which are available from here: http://www.sqlsoft.co.uk/ Newly...

Will

11-07-2009 03:44 PM
Will

Hi - I am running SQL 2k5 Developer Ed on Win XP Pro, current on SPs and patches (my dev machine at the moment), server collation:...

Steve M

11-07-2009 08:45 AM
Steve M

Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular database development tools: " Database Workbench 3.4.2...

Martijn Tonies

11-06-2009 08:57 AM
Martijn Tonies

Hello, How can I backup multiple databases with the command OSQL from one instance, creating one backup file for each database? Is it possible? If...

Jota

11-05-2009 09:58 PM
Erland Sommarskog

In MySQL there is a command that will differentiate between a replace and an insert. If the data record exists in the database based on the primary...

ewm

11-04-2009 01:45 PM
Russell Fields

Any idea on how to default the date fields display to mm/dd/yyyy format in SQL Server Management Studio 2008. This used to be working fine in SQL...

rkbnair

10-26-2009 05:41 PM
Erland Sommarskog

Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular database development tool: " Database Workbench 3.4.1...

Martijn Tonies

10-26-2009 06:44 AM
Martijn Tonies

http://www.nobhillsoft.com/MarieAlix.aspx You can read all about it on the above web page, but basically, its a very ambitious project to create...

Itamar, Nobhill Software

10-23-2009 03:42 AM
Itamar, Nobhill Software

the results of my query ( I'm using the sp designer in VS '08 Server Explorer) .. when it returns query result to Output panel ... even for...

Webdb_Advisor

10-22-2009 04:10 PM
Webdb_Advisor

SSDataWorks 1.0 is a data modelling tool for Microsoft SQL Server 2005 / 2008. SSDataWorks provides a powerful development environment allowing...

Eman72

10-22-2009 11:09 AM
Eman72

Hi, Trying to get to grips with VS for Db Prof (2008). I'm trying to deploy a db as part of running unit tests. Deploying onto SQL Express using...

Craig_dt

10-19-2009 04:36 PM
Craig_dt

I inherited serveral SQL Server 2005 database servers. How can I determine if the database servers have SQL Server 2005 Profiler set to...

Joe K.

10-10-2009 01:11 PM
Dan Guzman

Hi, One of the nice features of SQL2008 is the ability to give a color to the connection. We have setup an SQL2008 Central management server to...

Chris Wood

10-09-2009 05:56 PM
Chris Wood

There are certain items that are not allowed to drag and drop in the SSIS designer (BIDS 2005) but you can double click on the item in the toolbox...

Ben Miller

10-05-2009 06:00 PM
Ben Miller

I have a text file whos rows are terminated with 0A (NewLine). When I try to bcp IN these rows using -r"\n" which is the NewLine character it yields...

Snake

10-02-2009 05:28 PM
Erland Sommarskog

Hi all, We are planning to standardize on using SQLDiag (SQL2K5 and SQL2K8) to collect the diagnostic information from our SQL Servers. The...

Vikram Vamshi

10-01-2009 04:47 PM
Vikram Vamshi

I have just configured AS 2008 on our QA environment and attempted to build a cube. It has been in the Project Server queue for over an hour and no...

Jeff Hall

09-30-2009 06:24 PM
Jeff Hall

Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular database development tool: " Database Workbench 3.4...

Martijn Tonies

09-29-2009 11:33 AM
Martijn Tonies

Hi, When you install SQL2005 it also installs Office 2003 Web Components. I guess that you cannot replace them with Office 2007 software so can you...

Chris Wood

09-28-2009 07:50 PM
Aaron Bertrand