TEM TYÖ JA ELINKEINOMINISTERIÖ ________________________ Helsingissä 27. päivänä toukokuuta 2008 "Mielipiteitten esittäminen julkisuuteen nettiin...

Roos

01-29-2009 11:24 PM
Roos

I am running a SQL Profiler trace and exporting results to a SQL table. When I select distinct eventclass from the table, I get these 3 eventclass...

Neufusion

01-29-2009 06:08 PM
Erland Sommarskog

Thanks, but I checked all of that, and it is as you say. I even re-started the SQL Server Agent. But the same error re-currs .. it's as if it's...

Steve M

01-29-2009 02:30 PM
Steve M

In VS2005 I am connected to the SQLExpress instance. I acually have 3 instances of SQL Server on my machine (I am doing some crazy stuff). Currently...

EagleRed@HighFlyingBirds.com

01-29-2009 10:39 AM
Aaron Bertrand [SQL Server MVP]

I have a serveral SQL Server 2005 stored procedures that I would like to test with a tool to determine if there are indexes that could be added to...

Joe K.

01-28-2009 06:23 PM
Erland Sommarskog

One of my maintenance plans has mysteriously disappeared out of the management studio. Does anyone know where they are stored inside the database and...

David Hills

01-28-2009 10:12 AM
Aaron Bertrand [SQL Server MVP]

I installed a SQL Server 2008 Express today on my local machine, and after a successful local installation, I tried to connect (from the SQL Server...

Sorin Dolha

01-27-2009 06:38 PM
Aaron Bertrand [SQL Server MVP]

When in SSMS, I right-click and goto properties I get: Msg 8115, Level 16, State 2, Line 11 Arithmetic overflow error converting expression to data...

sql411@nospam.com

01-27-2009 06:03 PM
sql411@nospam.com

hi, i am running sql server 2005 profiler on a system, where not much space is left on c:\. that way i have configured profiler to write all files...

Fritz Theiss

01-27-2009 12:04 PM
Fritz Theiss

2005 BPA fails to scan. It is installed on a Windows 2003 SP2 server. Click "Select options fo a new scan" and choose "Computer name". Type anything...

Hexen29

01-27-2009 05:01 AM
Hexen29

I have a SQL Server 2005 database that I would like to change the database collation value. I will create new database on a new instance of SQL...

Joe K.

01-26-2009 06:14 PM
Joe K.

I'm calling off a stored procedure from C# (using ADO.net). Sometimes it returns data but sometimes it throws a timeout exception. I'm running...

0to60

01-24-2009 06:40 PM
Erland Sommarskog

Is there away to script out the recommended changes create by the SQL Server 2005 database tuning advisor? Thanks,

Joe K.

01-23-2009 11:16 AM
Joe K.

Hello -- The Wizard leads me through finding and adding the mdb files, and then shows the following error in the step "Connect to SQL Server...

slmehl420@gmail.com

01-23-2009 10:49 AM
Itamar, Nobhill Software

Good Afternoon Is it possible to set up a mirror just using FTP if it is, any tutorial etc on how to -- Thanks

David Hills

01-23-2009 10:20 AM
David Hills

Forgive the "cross-posting," but I wasn't sure of the best group for this question. I am installing some software on SBS 2003, and it appears the...

John Cradock

01-21-2009 08:44 PM
John Cradock

I am new to this tool and have a general question. Is it possible to set up a SQL Maintenance Plan that guarantees an atomic backup of a set of...

Sophie Bunce

01-21-2009 04:29 PM
Itamar, Nobhill Software

I would like to use the SQL Server 2005 database tuning advisor for my one of database on this database server for tuning indexes. Should I create...

Joe K.

01-21-2009 03:43 PM
Joe K.

Good morning My sql installation only shows the local C drive and D drive as locations to pick a backup file for a restore from. I need to restore...

David Hills

01-21-2009 06:49 AM
Tibor Karaszi

I am trying to develop a script(s) that can retrieve a list of .sql files names to be executed and then call sqlcmd for each file name. The...

RJ

01-20-2009 06:01 PM
Erland Sommarskog

Good Morning I have a sql server maintance plan that creates a full backup every day and calls the bak file Live_YYYYMMDDHHMM.bak where yyyy...

David Hills

01-20-2009 09:49 AM
Russell Fields

DWalker07 (none (AT) none (DOT) com) writes: You keep your code under version control, and when you need to change a file, you check it out and...

Erland Sommarskog

01-15-2009 06:07 PM
Erland Sommarskog

Column order. Hi, I have an index on a table: Unit, BusDate, Quantity, RetailPrice, UniqueRef, POS, Product When I analyze a query the DTE...

Paul

01-15-2009 04:42 PM
Russell Fields

When I right-click on a proc and select "Modify", or select "Script Stored Procedure As/Alter To/whatever", the Alter statement is preceded by: SET...

DWalker07

01-15-2009 03:46 PM
DWalker07

I run BPA on my pc and i received the following from my BPA report. "A significant portion of SQL server process memory has been paged out". i...

Yee Beng

01-14-2009 07:54 PM
Shirley Wang [MSFT\SQL]

Hello All, I am charged with using SQL Profiler for the purposes of auditing the use of SQL accounts with elevated privileges. These are...

rich

01-13-2009 06:11 PM
Erland Sommarskog

hi, in order to troubleshoot a given scenario i have to find out, which stored procedure, etc. is firing as a specific piece of t-sql code (which...

Fritz Theiss

01-12-2009 04:11 AM
Fritz Theiss

Could folks with SQL Server 2005 and/or 2008 Enterprise Edition tell me what exists in the folder \Microsoft SQL...

Patrick Jackman

01-12-2009 01:47 AM
Patrick Jackman

Good Morning can some one point me in the direction of a good simple overview of back stratagy for sequal server. I'm running axapta, I run a full...

David Hills

01-09-2009 06:06 PM
Erland Sommarskog

-- Thanks David Hills

David Hills

01-09-2009 06:10 AM
David Hills

Hi, I noticed this issue across all sql server 2005 servers in our environment. When we create maintenance plan (using wizard) for specific user...

Pedja

01-08-2009 10:46 AM
Aaron Bertrand [SQL Server MVP]

Hi, How can i send an email from sql server base in a query result in schedule time ? SA

S.A.

01-06-2009 06:57 AM
S.A.

Hi guys, I'm using BCP to import a CSV file into a database table, using the following command: BCP .dbo. in "" -e "" -T -c -t, -r\r\n The import...

Steve Barker

01-06-2009 05:05 AM
Steve Barker

Hi, I have database mail setup and running on SQLServer 2005. I was able to receive test mail. I created an operator with a valid email, configure...

Han

01-05-2009 05:57 PM
Han

I have a problem using the Microsoft SQL Server Manager Studio, the tool can open without any problems but every time you access the browser sends an...

yera_2002@hotmail.com

01-05-2009 05:38 PM
Erland Sommarskog

Hola a todos, Tengo un problema con la herramienta Microsoft SQL Server Manager Studio, puedo abrir la herramienta sin problemas pero cada vez...

yera_2002@hotmail.com

01-05-2009 04:21 PM
yera_2002@hotmail.com

I registered a SQL Server 2005 in SQL Server Management Studio 2008. I see the Maintenance Plans for the 2005 Server but cannot display or modify...

Norbert Meiss

01-05-2009 02:51 AM
Norbert Meiss

I am trying to use the Database Engine Tuning Advisor. I have the developer edition of SQL2005 and SQL2008 installed with several databases on each....

James Martin

01-05-2009 12:24 AM
Mark Han[MSFT]

First of all happy new year to all. I could not restore the bak file to sql server 2000. i rescued the bak files from a formatted hard drive. Now i...

yahya kemal kaya

01-01-2009 12:22 PM
Ekrem Önsoy

Hi all, If I add the View Designer or Query Designer toolbars they remain greyed out no matter what I do. What is the point of this. If this...

Jarryd

12-31-2008 11:49 AM
Rick Byham, \(MSFT\)

As I am often called to move from desktops to desktops, I would like to be able to install SQL Server Management Studio Express (2005 0r 2008) to a...

Sartos

12-30-2008 12:49 PM
Rick Byham, \(MSFT\)

------------------------------------------------------------------- :::: Great Indian Developer Summit 2009 - GIDS .Net :::: :::: 24 April 2009...

Shaguf

12-26-2008 12:31 AM
Shaguf

I'm using SQL Server 2008 SSMS against a SQL 2008 database and have a question about permissions. As a test, I gave a sql authenticated id Select...

Toni

12-24-2008 06:28 PM
Erland Sommarskog

Hi, I have used the DTA on this query... SELECT TI.Unit, TI.BusDate, TI.Product, TI.PLU, SUM(TI.RetailPrice) AS RetailPrice, SUM(TI.Quantity) AS...

Paul

12-22-2008 05:59 PM
Erland Sommarskog

I have a SQL Server 2005 database with SSMS. I am trying to use the toolbox but it has the SQL Server maintenance plan tasks that is grey...

Joe K.

12-19-2008 11:13 PM
Joe K.

I've just started at a new company that is using java and hibernate to access SQL Server. I tried configuring SQL Profiler to show me what sql calls...

Erik Sampsell

12-19-2008 03:11 AM
Erland Sommarskog

I have a DB that was put on a temporary server, which has SQL2005. I need to transfer the DB back, but the original server is SQL2000 SP2. I found...

Jason A Ash

12-18-2008 08:37 PM
Jason A Ash

I have SQL 2005 x64 and need to install SSMS on x86 system. When I try to run the install from the CD, I get an error: 'D:\Setup.exe is not a...

MichAda

12-16-2008 05:51 PM
Aaron Bertrand [SQL Server MVP]

Rancho Santa Margarita, CA -- 16 December 2008 -- theKompany.com, producers and distributors of high-quality open source and commercial Linux...

smga3000

12-16-2008 02:52 PM
smga3000

SQL Server Management Studio 2005 (SSMS) has started having problems rendering to screen: The query results grid is sometimes just a fine grey...

Charles Benett

12-11-2008 04:41 PM
Aaron Bertrand [SQL Server MVP]