Bob Hovious (3/5/2009)

---

Yes, it is doable. The code at the bottom produces two result sets with the column names you want to see. I have...

Thanks everyone,

I guess i had my answer, what i need to do right now is go and ask admin db for backup file.

(in my case, it is not steal,...

Gianluca Sartori (2/16/2009)

---

From BOL:

Backing Up to a File on a Network Share

For SQL Server to access a remote disk file, the SQL Server service account must have access to the...

I don't have permission to access remote computer, so i can't copy to my computer

sol

AJ (4/14/2008)

---

I know that the new version of SQL Prompt is paid.

Fortunately, when they had just begun with the project, they had free distribution of the software, which i have...

Yeah, I understood what you mean.

Regards

Sol

Personaly, I don't think use "like" is a good idea.

Because user can input "%" or "*" in their input string and so, your condition will fail to compare these...

To @hari.Shama:

Thanks for your help.

I checked and it worked but it seem confuses to me when use this one.

To @gilamonster and @michael-2...

From what you said, there is no way to disable "sa" account in sql 2000, isn't it?

I used default name when install sql server.

I have some version of SQL on my computer: 2000 , 2005 with two instance.

When i used osql -L , i can...

Thanks for your answer.

But, as the picture i have posted, the server name ( in the red rectangle ) is "lntai\sqlexpress_test", meanwhile, my computer name is "lntai", not "lntai\sqlexpress_test".

So, as...

Thanks your advise .

I will see how i can get what you said.

Thanks again.

It's exactly 507 records , the same when have "distinct". Because this, I have confused. ???

About my SQL statement , i will post it in here in the short time...

Thanks.

But do you know another way to read info from log file (*.ldf) or how to know exactly who is the one insert , update or delete record on a...

Thanks for your answer.

I watched the Excution Plan and saw what you said, but what i mentioned is why have difference between 5'' and 55'' when you just add "distinct"...