Initially I had created a Perf Counter Log job that would save it to a text (csv) file. Recently I decided to start saving the information to SQL...

Carlos

06-30-2008 02:48 PM
Sean McCown

SSMS 2005 : Is there a way to configure the default "database"/"initial catalog" for connections to a certain server/instance to something other...

John A Grandy

06-27-2008 03:33 PM
Ekrem Önsoy

Hi - I have looked in help, but was wondering if someone has some ~specific tips on querying the ft index files themselves to determine & report...

Steve M

06-27-2008 02:48 PM
Steve M

So, if I open a SQL Script in Microsoft SQL Server Management Studio and save it with a new file name, then edit it, it keeps the old name in the tab...

Ion Freeman

06-25-2008 04:35 PM
Aaron Bertrand [SQL Server MVP]

My SQL Server Agent service runs under a domain account on a member server to do most of its work. Currently there is a maintenance plan step to save...

coconet

06-23-2008 06:13 PM
Erland Sommarskog

Hi all, I am very pleased to announce the release of a new version of DMC ( 1.4.0.1 dated 23/06/08) New Feature : SQL Environment - work on any...

Jean-Pierre Gutsatz \(DMC\)

06-23-2008 05:13 PM
Jean-Pierre Gutsatz \(DMC\)

Hi 2 questions: 1) It is possible to tell from "Help About" in QA for SQL Server 2000 which service pack has been applied? Note: I am _NOT_ talking...

Stephen Howe

06-23-2008 12:13 PM
Rick Byham, \(MSFT\)

We have SQL server 2000, SP3. Whenever I go into Enterprise Manager(on either the server itself or on my desktop Enterprise Manager) and click on...

Ludwin Pacheco

06-21-2008 12:32 PM
Ed Murphy

Hi, My apologies if this question is not suitable to be posted here.. We are facing an issue while moving a Sql 6.5 database to a Sql 2000 server...

just55

06-20-2008 06:38 PM
Erland Sommarskog

I'm trying to BCP out a temporary table (this is actually occuring in an application and with the connection still open that "owns" the...

Thomas W. Brown

06-20-2008 07:22 AM
sifobo

Dear all, Sifobo Enterprise Manager for Oracle And SQL Server is an MMC based Oracle and SQL database backup manager for Windows and available...

info@sifobo.com

06-18-2008 12:46 AM
info@sifobo.com

as title , anyone know , thank a lot

Ken

06-16-2008 05:40 AM
Ken

In both SMSS and Visual Studio, there are icons to comment out lines (looks like a stack of parallel lines, with the top and bottom lines longer on...

Ed White

06-16-2008 05:17 AM
Charles Wang [MSFT]

Good morning, I do not have much experience in SQL, which is why I need your help. What steps should I continue to make a running SQL server and...

Justo

06-15-2008 06:18 PM
Erland Sommarskog

We have a User table with 2million records in them, that has 4 indexes set for faster Search. At an average we have 187k new records coming into...

QSIDeveloper

06-10-2008 05:58 PM
Erland Sommarskog

I'm aware that profiler can show duration in microseconds. I'm running a trace for a specific DB where the duration is incorrect. If I...

KevinL

06-07-2008 11:33 PM
Linchi Shea

Hi all, I get this problem when a double clic on a .sln file of a SSIS project: Microsoft Visual Studio --------------------------- The application...

Luigi

06-07-2008 07:38 AM
Chakravarthy

hi! I use ms sql 2005 "Generate Script Wizard" to generate table schema Most tables' script are normal,except one. the script snippet is as...

YesGoGoGo

06-07-2008 03:09 AM
YesGoGoGo

Do we have any free Intellisense for SSMS? I know of red gate's SQL Prompt, for which we have to pay

VK

06-06-2008 05:22 AM
VK

I am using SQLCMD.EXE of SQL Server 2005 for the automation of my installation scripts. I wanted to make use of transactions when inserting data into...

....DotNet4Ever....

06-03-2008 05:59 PM
Erland Sommarskog

I am currently using SQL Server 2000. I have a production database and an instance. The instance is mainly for web display. What I would like to...

Hoardling1 via SQLMonster.com

05-30-2008 06:10 PM
Erland Sommarskog

I have the follwing error message when I try to create a Job in SQL Server 2005 "Unable to cast object of...

Paulo Pina

05-30-2008 03:55 PM
Subhen Kar [MSFT]

Assuming I have 5 per server licences for SQL 2005 Standard Edition servers and I had and 50 clients with SQL CALs I believe I can install SQL...

Brendon

05-30-2008 01:27 PM
Ekrem Önsoy

Hi all, Is it possible to import data from xsl SQL Server Express? Clara thank you so much for your help

clara

05-30-2008 05:05 AM
Jean-Pierre Gutsatz \(DMC\)

Hello, Does anyone know if it is possible to schedule an automatic backup of sql database through SQL Server Management Studio Express? I have heard...

James Landon

05-29-2008 04:44 PM
Aaron Bertrand [SQL Server MVP]

Hi all, Quick question. At my current job, we are looking to install an Access frontend that connects to our main database. This would involve...

iaingblack

05-28-2008 10:40 PM
Andrew J. Kelly

Hi all, I don't know why there is no Management Studio after I install SQL Server 2005 Developer Edition. Is something wrong during the...

clara

05-28-2008 03:06 PM
Ekrem Önsoy

Hi All, If any body can suggest me on the following questions. (1) Does SQLServer can extract data from Lotus Notes DataBase. (2) What are the...

Ram

05-28-2008 04:08 AM
Ed Murphy

Hello all, It will have been a short - long wait for some of you :) One day a client told me that is only DMC could be portable - then ..... We...

Jean-Pierre Gutsatz \(DMC\)

05-27-2008 11:21 AM
Jean-Pierre Gutsatz \(DMC\)

Hello, I'm not sure if I'm posting to the correct group, but I don't see a microsoft group explicitly for data minig and I would think SSAS falls...

drolaw

05-24-2008 05:35 AM
Erland Sommarskog

hello all, i know ssis allows to insert from a csv file into sqlserver (2005) tables but is it possible to either update and/or delete records with...

lark

05-23-2008 07:59 PM
drolaw

Does anyone know if there are any outstanding requests on the Connect site asking that the table designer in SSMS please stop automatically...

Jeff Johnson

05-23-2008 06:11 PM
Erland Sommarskog

Hi, I have a table with more then 500000 records. I'm trying to search for a part of word in a description-column (char50), normally I take the like...

Geert

05-22-2008 10:28 AM
Daniel Crichton

Dear reader, Upscene Productions releases Database Workbench Pro v3.1.1 which fixes an issue with the trial version under Windows Vista as well as...

Martijn Tonies

05-22-2008 02:57 AM
Martijn Tonies

I installed Visual Studio 2008 on a Vista box. After Visual Studio loaded SQL 2005, I try to install SSMSE, but it always fails with error code...

Doug

05-21-2008 03:19 PM
Sean McCown

has anybody ever used sftp to tansfer file? is there a way to do this in sqlserver 2000 and/or sqlserver 2005? thanks in advance.

lark

05-21-2008 04:46 AM
jhofmeyr@googlemail.com

I am attempting to submit a trace table to the Database Engine Tuning Advisor for analysis. Each attempt appears to process for about 45 minutes or...

bchristensenpager@gmail.com

05-19-2008 06:03 PM
bchristensenpager@gmail.com

I have maintenance job the runs a Reorganize/rebuild indexes. It normallly takes 90minutes to do all DB's but on occassion it gets hung up. The...

Jay Bukstein

05-15-2008 12:21 PM
Ola Hallengren

I'm using both SQL Server 2000 & 2005. I often perform queries and need to copy the (grid based) results into Excel 2007. The problem is, the...

BillG_SD

05-13-2008 05:40 PM
Erland Sommarskog

I have submitted the following as a Feedback item in the SQL 2008 Books On-Line. In case anyone is interested, or if it's already...

David Walker

05-13-2008 05:39 PM
Erland Sommarskog

Hi; First Question: What is the difference between ATTACH and COPY in SQL Server 2005? -- Sincerely Siamack Hejazi Sale Accounting Department...

Siamack Hejazi - HotMail

05-13-2008 03:11 AM
Erland Sommarskog

I have 3 windows xp (sp2) computers running SQL Server 2005 (Dev edition) with the same SAC connection error as follows: Computer localhost does...

Brett Zimmerman

05-12-2008 07:15 PM
Brett Zimmerman

I can never seem to get the filters to work in SQL Profiler. I've tried to set HOSTNAME and NTUSERNAME to mine however when I run the trace...

Wayne Blosat

05-12-2008 03:42 PM
Aaron Bertrand [SQL Server MVP]

I have data in a text file that contains the Lender Number. 789 $4,000 May 2008 456 $5,000 May 2008 I require the Lender name that is contained in...

Query Analyzer User

05-12-2008 02:19 PM
Tom Moreau

I have a table containing Hebrew charachters When I run String functions such as LEFT & SUBSTRING, that results returned are in revers order. I.E:...

lshaki@gmail.com

05-12-2008 09:51 AM
Russell Fields

We are using SQL Server 2000. I want to copy a bunch of stored procedures from the development SQL server to the live SQL server. Is there a tool...

Brad Pears

05-09-2008 12:55 PM
Brad Pears

Hi All, (We know advertisement is not allowed here, but since this one is free we hope we're not breaking any rule). We wanted to let you all know of...

Jonathan Sion

05-08-2008 04:24 PM
Jonathan Sion

Hi: I set up tLog shipping between two sql2005 servers in a 2003 AD domain. Everything is working, but I have a couple questions. The primary dB is...

geekyguy

05-08-2008 02:02 PM
Andrew J. Kelly

Hi all, in SQL Server 2005, when I make desing modifications in tables structures, the database diagram (already made) does not reflect these...

Luigi

05-08-2008 10:39 AM
Luigi

When I press OK button in new database window of management studio the following error message appears: "Collation '<predefinite del server>' is not...

emmetonda

05-08-2008 04:26 AM
emmetonda