Lamprey13 (12/15/2010)

---

landingnormand (12/14/2010)

---

Hi GSquared,

Again, thanks for the reply.

I know comma-delimited lists for parameters isn't ideal but I don't know of an alternative (in 2005). The function I have used...

evald (12/15/2010)

---

Paul White NZ (12/15/2010)

---

evald (12/15/2010)

---

...I'm just trying to say that if the order clause is not working in some cases for some reason than its useless and confusing give...

What DBA ?...

Not sure why you are moving Master but just in case I'm confused in your reasonings

read

http://support.microsoft.com/kb/264474

and this

http://www.julian-kuiters.id.au/article.php/sql2000-restore-master-database

CodeOn

😛

you can run the 32bit on the 64bit machine, you only have 4 gig so it doesn't matter.

QUOTE $10,000.

CodeOn

Or someone is trying to activly mask the originating accoiunt accessing the SQL server. I'd caution against allowing this type of access.

Been doin' this for...

Change the query timeout value to zero (0). this means no timeout enforced by SQL server. I would also make very sure that the code that the WebUser...

Have a look at the linked server options.

1. Connection timeout, and

2. Query Timeout

try setting these to 0

Also have a look at the target and the originating server...

Does the WebUser have permissions on the Target server? and have you checked the network connection between the two servers?

And then someone says this

"the company has no dedicated dba. So the credentials are out there in various web or app config files." And you wonder why hackers...

Uhhh. Because it's a SQL server NOT a firewall. What Idiot would expose a SQL server to the wilds of the internet for it to act as a...

Not to put a too finer line on this but ....... this is a Red gate sponsored community server.. Correct ? I have been using SQL Backup for...

Being "Captain Obvious" here.... it's an error log. Open the log file viewer and check if there is an active filter. Also by default the Error log open...