revised -- KPoku "Ekrem Önsoy" wrote:

opokad06

12-08-2008 11:32 AM
opokad06

Hello: How do you install SQL 2005 Tools (Mgmt. Studio) on a Vista laptop? I successfully installed SQL 2005 Standard Edition including service...

childofthe1980s

12-06-2008 03:11 PM
Paul Shapiro

I have a maintenance plan that is supposed to back up the transaction logs for six different databases from the same server. However when it runs...

Sonia

12-06-2008 09:51 AM
Sonia

Also I am trying to sending backup notification using smtp. This is the code I am using.. ------------------------------------- CREATE PROCEDURE...

opokad06

12-05-2008 04:04 PM
opokad06

My sqlserver has TABLE_A. I want to pull data from Other database DB2.TABLE_A at regular interval of 10 min. The DB2.TABLE_A and SqlServer.TABLE_A...

M8080

12-05-2008 03:04 PM
M8080

I developed a SQLCMD batch file that I run on a sql 2005 server . On the single server copy of 2005 it works fine. SQLCMD -U loginame -P...

Brian Wilkins

12-04-2008 08:26 PM
Geoff N. Hiten

I two computers having the same problem. One is running XP home, one with XP pro both with sp3 both running SQL 2005 developer version (OS v...

Mac

12-04-2008 12:36 PM
Mac

I am connecting SQL server from Linux. Is there SQLCMD like utility Microsoft provide for Linux batch sql jobs also. Thanks

Avin Patel

12-03-2008 05:02 PM
Russell Fields

Hello, We would like to use SQL Mirroring as a high availability option for our production environment. Our user databases are not a problem. It...

Steven

12-03-2008 01:11 PM
Dave Sundell

I need to setup profiler to capture which databases are being used and which tables in those databases are being accessed. For the life of me I can...

Snake

12-02-2008 05:28 PM
Erland Sommarskog

Hello, I am trying to use the Reporter from the RML Utilities. In the Reporter GUI, I setup the database I want to work with, I define a database (I...

Vincent D.

11-28-2008 12:48 PM
Mohit K. Gupta

Hello, I need some help with an issue displaying numeric amounts as numbers in excel. what I have in the report file: - report dataset exposing...

newsgroup.poster@gmail.com

11-27-2008 05:15 AM
newsgroup.poster@gmail.com

Hi all, We are very pleased to announce that a new version of DMC is available http://www.dmc-fr.com/home_en.php We have added a new feature in...

Jean-Pierre Gutsatz \(DMC\)

11-26-2008 01:13 PM
Jean-Pierre Gutsatz \(DMC\)

Hi there, if I am connected to a server in object explorer and I then open a query window or open a file, is there any way that I can get Management...

Waldy

11-26-2008 12:02 PM
Waldy

We're using Sql Server 2005, Win2003 and writing backups to an HP Ultrium2 tape drive. I can get a File List from the tape with no problems. I'm...

frostbb

11-26-2008 01:06 AM
Jeffrey Williams

I used the code below, what the difference between @command and fullPathName? CREATE TABLE #BackupFiles (FullPathName NVARCHAR(256)) DECLARE...

opokad06

11-25-2008 02:07 PM
Russell Fields

In our environment all jobs are scripted, we do not use maintenance plan. Is there a script that I can add to my jobs that will run daily and...

opokad06

11-25-2008 01:57 PM
opokad06

Hello, I have seen and used a bit of Quest Foglight, Spotlight and PA. Of late, I checked out Ideras Diagnostic Manager and found it pretty...

RR

11-24-2008 11:14 PM
Aaron Bertrand [SQL Server MVP]

*Yleisön pyynnöstä alan julkaisemaan Suomen ydinaavikoitumisen nykytilastamme kertovaa faktaa. M.T.05.05-08. Ilmatieteen laitos. PAIKKA SADE...

Jonne Korhonen

11-21-2008 12:35 AM
Jonne Korhonen

Hi All, We are very close to releasing a new SQL Server utility product. The product works well with the databases we have tried, but we would like...

Wingenious

11-19-2008 07:15 PM
Wingenious

I created a test table to demonstrate my problem. CREATE TABLE .( (5) NOT NULL, (9, 0) NOT NULL, (5, 2) NOT NULL, (6, 2) NOT NULL, (9, 0) NOT...

JOHN KEANE

11-19-2008 08:47 AM
JOHN KEANE

I have been trying to get the SQL Server 2005 Enterprise Edition setup to run on my Windows Server 2003 machine without success. I double click...

Ken

11-18-2008 12:45 AM
Mark Han[MSFT]

I am trying to setup SQL client configuration to setup an alias for a DNS name or server name . I am supplying either DNS or Server, plus port...

Mike B

11-17-2008 04:52 PM
Mike B

I have four SQL Servers running with databases on each one. Some of my server's drive space is running a little low, so I'd like to backup all of...

Greg

11-17-2008 02:31 PM
Greg

I created a job to test the other day and now I want to delete/drop it. When I choose the Delete option from Management Studio I get the following...

Greg

11-17-2008 02:29 PM
Greg

I don't see it in the download center yet I've been told a new instance is available.

Hillbilly

11-16-2008 01:43 PM
Karim Moussa

I'm looking for a way to install the SQL Server 2005 Tools onto client machines, does anyone know of an easy way to do this? I'm guessing our...

LouanneD

11-13-2008 08:57 AM
LouanneD

How does Microsoft SQL Server 2008 Reporting Services Report Builder 2.0 differ from the editor included in Visual Studio 2008? Would it be better...

Harolds

11-13-2008 08:24 AM
Charles Wang [MSFT]

I have the following situation: Machine with SQL2008 express installed. Restored Backup from previously existing database of different...

Ian Michael

11-13-2008 06:16 AM
Ian Michael

Hi! SQL Maestro Group announces the release of MS SQL Maestro 8.11, a complete Windows GUI solution for SQL Server 7/2000/2005/2008 admininstration...

SQL Maestro Team

11-13-2008 04:56 AM
SQL Maestro Team

Good afternoon, I've been trying to install SQL Server Management Studio on my laptop with no luck. I am running windows xp professional sp 2. It...

Laura

11-12-2008 02:56 PM
Mike Grimm

I am trying to create a template in SSMS and when defining a parameter like: <valuation, numeric(18,1), 2.0> and then hit CTRL+SHIFT+M, I get "1),...

Jiho Han

11-12-2008 12:50 PM
Jiho Han

I'm attempting to run some traces using profiler under SQL2000. I've noticed that it appears to use some temp space out on the C drive for some of...

Tom Frost

11-11-2008 11:50 PM
Mark Han[MSFT]

Hi, we just upgraded to SQL Server 2005 and I have a minor issue hand- editing data in SQL Server Management Studio object query results as I'm...

Robert Carnegie

11-11-2008 12:26 PM
Robert Carnegie

Thanks Ekrem, the logs did show me some important info (as in which msi setup was used to install the tool). Thanks for the help mate! "Ekrem...

Ajit

11-11-2008 08:19 AM
Ajit

I'm looking at deadlock graphs in profiler and I see a lot of situations where the killed process does not have a request or owner arrow, thereby...

myotheraccount

11-10-2008 06:17 PM
myotheraccount

Hi, I'm trying to install SQL Server 2005 on my HP DL360 G5 server running MS Server 2003 R2 STD Edition. I need it for Backup Exec and Blackberry...

Dave Cason

11-10-2008 01:44 PM
Mohit K. Gupta

I have not used DTA more than a couple of times. Running against this trace file I keep getting the error "Invalid object name '??'� on all the...

Stevecin

11-06-2008 08:11 AM
Stevecin

Perfect. Many thanks for that. I'm still not used to that option being required in 2008 and never thought to look. I figured I needed to do that...

James Buist

11-03-2008 07:21 PM
James Buist

Hi. I have a .trc file created by SQL Profiler of SQL Server 2005. I need to open the .trc file in another machine which has only SQL Server 2005...

playplay1978

11-02-2008 10:55 PM
playplay1978

Hi, Quite regularly when using Management Studio (SP2) on Vista Business SP1 when I try to open a script file (either Ctrl-O or using toolbar) the...

Devious Devil

10-31-2008 02:12 PM
Devious Devil

I'm having an issue where there isn't apparently enough disk space on the local C drive to create the temporary files used to create the backups. ...

John S. Pandolph

10-28-2008 05:34 PM
Erland Sommarskog

I am having the same problem on all 6 of our SQL servers with the backup job not deleting .bak files after a certain amount of days. The Microsoft...

Tim Shoemaker

10-28-2008 08:29 AM
bspolarich@advancedphotonix.com

Hello, and thanks for your assistance in advance. I am running Sql Server 2008 Express with advanced services. Every time I run a sql script, it...

TJ

10-27-2008 02:10 PM
TJ

Hi everyone, as you can read in the object, in our production server ssms version differs from that of the db engine. In fact we have 3042 for...

Luca Carraro\(FiloDiArianna.it\)

10-25-2008 03:16 PM
Luca Carraro \(FiloDiArianna.it\)

Can I use SQL 2005 Management Studio to manage SQL 2000 servers? Please let me know. Thank you

dave

10-24-2008 12:06 PM
Russell Fields

Does SQL server have any tools or utilities that I can use to publish the diagrams to a web page? I want to make the schema diagrams available...

Omid Golban

10-23-2008 04:52 PM
Roy Harvey (SQL Server MVP)

I have spend endless hours with Symantec Tier 2 support resolving the

Kashif

10-23-2008 11:49 AM
Rick Byham, \(MSFT\)

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

Martijn Tonies

10-20-2008 07:22 AM
Martijn Tonies

Is there a utility to read the transaction logs for SQL Server 2000? What about SQL Server 2005? I need to review the transaction logs for two of...

Ellen

10-17-2008 03:30 AM
Manpreet Singh