sounds more like you are trying to make your databases bend to the will of the backup program.

Veritas certainly has the ability to backup a database that is in SIMPLE...

I didn't see your previous post, but are you looking for @@SPID?

select @@SPID will give you your current connection id, is that what you are looking for?

here's a collection of...

ian your expanation doesn't make sense. half a case would be 6 bottles in a 12 unit case, right? where did "the actual stock is 33 cases and 3 bottles...

[facepalm] oh snap!

so obvious when someone rubs your nose in it; thanks

ok this is providing a fun learning curve for me;

generating a calendar table's easy, but updating it to have holidays is tripping me up.

all the holidays that are ...

there's some articles and webcasts here on SSC as well:

i remember reading an article "clustering in 15 minutes" but can't seem to find it.

Step-by-Step Guide to Clustering Windows 2000 and...

maybe you are refering to clustering?

clustering takes two or more servers, each with their real IP, and sets up a service so that they share any requests being services on...

glad you fixed it; what was the problem, and what was your solution? it might benefit some others if you can post some ideas and details.

Thanks!

HAJJAJ (3/15/2010)

---

the problem is solved.

yes...

how about this idea:

don't let them change the job, nor give them access to edit the job.

Instead, change the job slightly so instead of hardcoding those parameters, change it to...

Lukes right...that proc is returning more than one value;

run the proc all by itself, or try this as a proof of concept:

EXECUTE [db_name].[dbo].[proc_name]

--or capture the results to a...

you can use a case statement in the ORDER BY clause:

ORDER BY

CASE

WHEN <something that makes the first row first>

...

it does seem to me to be the WINS\DNS, wher ethe WINS service might not be returning the IP address connected to the name on th network;

i assume your...

the key you are looking for is sys.triggers; i think you'd have to schedule a job to email if the condiftion of is_disabled = 1 is ever found.

here's an example

name...

I'd seen this question here before, and i believe the SQL Engine install can only occur on the %SystemDrive% drive; in most cases that is the C:\ drive;

as already...

i think it is nothing more than clicking the green arrow/debug mode, when you should have hit execute:

i confuse them myself, because the arrow in visual studio means "run";