Thanks! I ma installing SP 2 in my production server. should I install it too to my mirror server? 🙂

This is my SQL server version and I still recieved the same error:

Microsoft SQL Server 2005 - 9.00.1399.06 (X64) Oct 14 2005 00:35:21 Copyright (c) 1988-2005...

Thanks for reply.

Right now I have SQL 2005 with SP2. but still recieved the same error.

please help!

Thanks!

Hi I tried this:

-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf;-T1400

But still recieved the same error. please help!

thanks

Hi can anyone please help me.... I have the same error:

when I run this query:

User Server01

EXEC master..xp_cmdshell 'MKDIR \\Server02\FolderName'

it retuned me this error:

Logon failure: unknown user name or bad...

Please help... I have the same error:

when I run this query:

EXEC master..xp_cmdshell 'MKDIR \\ServerName\FolderName'

I got this error msg:

Logon failure: unknown user name or bad password.

it works fine if I...

Hi I develop this query to defrag indexes that have 30% defragmentation (you can change the %). it also show you a report of before and after fragmentation. I hope...

I am having the same problem.

This syntax runs fine with my other SQL server except for my newly installed SQL server. I check all the permission and they all the...

yes I did...

Thanks guys, I monitor the task.exe and it open new cmd.exe that never terminated. now what I need to know is how to kill the cmd.exe using vb code. 😉

Actually I suspect that... hmmm is there anyway I can kill the cmd.exe in SQL.

Thanks!

it gives result to our SQL database.

I tried this but still give me the same problem. everything run ok it juts leave the cmd open

EXECUTE xp_cmdshell '"D:\Folder\Task.exe"

I have the same problem. My cmd.exe left open even the processes is already completed.

EXECUTE xp_cmdshell '"D:\Folder\Task.exe" & exit'

Can you please help me to solve this.

Thanks!