I have an OLTP SQL Server 2005 instance with about 40 databases. One of the heaviest hit databases has some “mystery data� showing up. I have...

Scagnetti

05-04-2010 06:02 PM
Erland Sommarskog

Hello: I receive an error with event ID 26: "MsFTEFD.exe - Application Error : The instruction at "0x0700609c" referenced memory at "0x00000014". The...

Matt R.

04-27-2010 05:28 PM
Matt R.

Hi, I have the following error when trying to connect to SQL Azure using BCP: Error = Login failed for u ser 'MYUSER'. The command line used...

Lilian

04-26-2010 01:39 PM
Alan Brewer [MSFT]

Hi! I just moved my development environment to a new laptop (i7 2.66 GHz, 8Gb mem) in Windows 7 Pro x64. A simple query in SSMS now takes minutes...

LarsJönson

04-23-2010 08:43 AM
LarsJönson

Hi all, my company makes a CAE tool which stores it's data on MS SQL Server. Recently one of our customers had a data loss, and he made a copy of...

Andreas G.

04-22-2010 05:35 PM
Erland Sommarskog

Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular multi-DBMS development tool: " Database Workbench 4.0...

Martijn Tonies

04-22-2010 05:46 AM
Martijn Tonies

SQL Server Management Studio Activity Monitor will not run against our production SQL Server 2008 Standard Edition SP1 Machine. It returns the...

Ivan Piacun

04-20-2010 09:49 PM
Ivan Piacun

SQL Server 2005 Database Engine Tuning Advisor informs me that I should replace query 1 below with the syntax in query 2 below. I’m just not...

Mike

04-19-2010 06:12 AM
eliza

Hi frnds need help regarding a query to compare two resultset and highlight those record which are not...

chintu4uin@gmail.com

04-12-2010 10:40 PM
Tom Cooper

In trying to BULK INSERT data with the following statement: BULK INSERT Ideas FROM 'C:\ideas.csv' WITH ( FIELDTERMINATOR =',', ROWTERMINATOR...

Will the Thrill

04-02-2010 12:31 PM
Will the Thrill

I have two instances of SQL 2008. One was upgraded from SQL 2000 and one was a clean, new install. SQL Mail operates perfectly on both...

cc

03-26-2010 07:30 PM
Sylvain Lafontaine

Hi, SQL server version - Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Recently I have started getting the following error when i try to create...

Manoj Kumar

03-24-2010 07:11 PM
Jeffrey Williams

DBTYP.NET Studio 2010 - Database Comparison Suite Released Vienna, Austria - March 8, 2010 Today, BYPsoft announced the availability of DBTYP.NET...

03-24-2010 02:40 PM

when textData is: exec sp_execute <number> @xx=2222 @yy=3333 Is there a way to find the sql behind the sp_execute?

MSUser

03-22-2010 04:54 PM
Erland Sommarskog

I am running the bcp utility under Microsoft Visual studio 2005 and receive the following in the progress log: Warning: File/Process "bcp" is not...

dashary

03-10-2010 05:36 PM
Erland Sommarskog

I'm a newbie to SQL Server and have asked to investigate monitoring tools. We're mostly interested in the basics... - is it up - has it been...

Chuck

03-10-2010 03:56 PM
alen teplitsky

DBTYP.NET Studio 2010 - Database Comparison Suite Released Vienna, Austria - March 8, 2010 Today, BYPsoft announced the availability of DBTYP.NET...

03-10-2010 02:18 PM

Wingenious has released a free utility for SQL Server developers, administrators, and contractors. The tool, DBGizmo, provides some of the features...

Wingenious

03-09-2010 07:03 PM
Wingenious

My office often gets accounting data from clients in the form of reports. These reports can be output into text files but we then need to parse the...

Jerry

03-08-2010 09:27 AM
Jerry

Hi there, I'm using SQL Server 2008 and I wrote Exec Master..xp_cmdshell 'bcp "Select * from Coronado.dbo.immunization" queryout...

odeddror

03-07-2010 07:26 AM
Erland Sommarskog

Hello all, This is for SQL 2000. A trace is being configured (through a service) with filters to monitor UPDATE, DELETE or INSERT commands in a...

Yba

03-05-2010 10:51 AM
Kalen Delaney

Since I am new to sql server report service 2008, I have the following questions to ask: 1. I have alot of reports that need to have one to 10...

Wendy Elizabeth

03-04-2010 07:04 PM
Wendy Elizabeth

SQLsoft is pleased to announce the official release of version 3 of SQLjobvis - a totally free tool for SQL Server 2005 and above. SQLjobvis...

Will Alber

03-03-2010 08:35 PM
Will Alber

Ok, I have SQL Server 2008 with a license by processor license agreement. I have SSMS installed on my local machine and am using it to access the...

Hoardling1 via SQLMonster.com

03-03-2010 03:25 PM
Hoardling1 via SQLMonster.com

We are planning on moving our desktops to Windows 7 and are in the testing phase. I have been asked to do the install of SQL Server 2005 SP3...

Loren Z

03-03-2010 11:51 AM
Loren Z

A month ago I upgraded a database from Sql Server 2005 to 2008. The fulltext indexes worked fine until recently. Suddenly nothing works. I've tried...

georgina

03-01-2010 09:14 PM
Robert Nicholson

Sorry didn't know where to put this question. We have implemented service broker on a database. The question I have is that has anyone come across...

Toby

02-28-2010 10:50 AM
Dan Guzman

Hi, I have a SQL 2008 DB I'm try to Publish as a SQL 2005 DB with the Database Publishing Wizard Tool. It gets all the objects OK... but scripting...

King Coffee

02-28-2010 09:38 AM
Erland Sommarskog

This KB was last reviewed in Jan 2009. This seems to still be a problem with side-by-side installations of SSMS 2005 and SSMS 2008, which is often...

ShadowFRJ

02-25-2010 12:17 PM
ShadowFRJ

I am trying to install the 64 bit SQL Server 2005 client tools on Windows 7. In the System Configuration check I am getting 3 warnings. The first is...

Loren Z

02-24-2010 02:10 PM
Jeffrey Williams

We have a requirement to install the the SQL Server 2008 Managament Objects onto a server that is running SQL Server 2005. The management objects...

Stephen E-G

02-23-2010 11:45 AM
Stephen E-G

Hi there, I'm using Microsoft SQL Server 2008 and MySql 5.1 on Windows Vista Business x64 I migrated MySql database into SQL Server using the SQL...

odeddror

02-22-2010 04:03 PM
Denis Vnukov

許多性能å•�題和安全性您的計算機é€*æˆ�惡æ„�病毒，最好的辦法å°�付，這是得到承èª�和防病毒在計算機上安è£�æ›´æ–° æ...

antivirus gratis

02-22-2010 02:31 PM
antivirus gratis

My computer is running on Windows XP SP3, with .net 3.5, SQL Server Express 2005 (I have uninstalled SQL2008 and downgraded to SQL2005). But I can't...

Raj

02-21-2010 10:51 AM
Raj

I have been asked to provide a list of all columns in all tables in a database. I have the output from "select * from sys.tables" and "select *...

thing

02-16-2010 09:03 PM
thing

Hi, as it's an open-source tool I take a minute to talk about Nautilus (http://sourceforge.net/projects/nautilus/) It's a tool made by (and for)...

Marcos Casamayor

02-15-2010 11:09 AM
Marcos Casamayor

Hi, does anybody offer specific scripts to monitor SQL Server with Nagios like with SCOM? Thanks for any advice Adrian -- Adrian Miller

Adrian Miller

02-15-2010 03:45 AM
Adrian Miller

Hi All, We've written a number of (I think!) handy (and free) tools over the past few months which are available from here:...

Will Alber

02-10-2010 03:22 PM
Will Alber

We are having performance issues with our software vendor concerning the performance of an application that uses SQL2005. The vendor thinks the...

mwebb

02-09-2010 09:15 AM
Geoff N. Hiten

Nuevo Modelo R4i para Comprar R4i para nintendo Ds, Ds Lite , Dsi y Dsi...

tesddalws

02-08-2010 01:06 PM
tesddalws

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 the...

Mia

02-01-2010 01:52 PM
Mia

Hello: I know that the security update that makes SQL 2005 be version 9.0.4053 is just that--an update. But, where can you go to download this? I...

childofthe1980s

01-29-2010 05:37 PM
Erik G

I just wanted to ask you a question about capturing SQL 2005 database transactions and later replaying them on the same database in the...

SSS

01-29-2010 05:20 PM
Erik G

Hello, Has anyone had an issue with all servers in the configuration tool not showing up in the reports. I've looked at the XML config file and...

Erik G

01-29-2010 04:58 PM
Erik G

ANN: Database Workbench 3.4.3 released! Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular database...

Martijn Tonies

01-28-2010 03:59 AM
Martijn Tonies

Hello, I use SQL 2000 on Windows 2003, and I have a scheduled job in my SQL Agent that runs this: declare @cmd varchar(2048) SET @cmd = 'bcp "EXEC...

Deniz

01-27-2010 07:18 PM
Deniz

Many problems with performance and safety of your computer can be solved easily with an updated antivirus and recognized. Antivirus Free...

antivirus gratis

01-26-2010 04:09 PM
antivirus gratis

Hi friends I m using SQL 2005 I want to concatenate multiple rows into single row with comma separated. I tried using for XML and all but what I m...

chintu4uin@gmail.com

01-25-2010 07:45 AM
Hugo Kornelis

Hello, I am using the SQL Server 2008 Management Studio on both Windows 2003 and Windows 2008 32 bit editions to manage several SQL Server 2008...

Peter_April1

01-21-2010 01:30 PM
Jeffrey Williams

Hi, I have a new post in my blog which ends with a simple 'monitoring habits' poll - if you can, take 10 seconds to participate. (or a bit more to...

Adi@SqlStripes

01-18-2010 03:50 PM
Adi@SqlStripes