Viewing 15 posts - 9,841 through 9,855 (of 13,469 total)
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...
March 17, 2010 at 12:18 pm
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...
March 17, 2010 at 9:06 am
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...
March 16, 2010 at 11:15 am
[facepalm] oh snap!
so obvious when someone rubs your nose in it; thanks
March 16, 2010 at 8:30 am
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 ...
March 16, 2010 at 7:42 am
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.
March 15, 2010 at 12:06 pm
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...
March 15, 2010 at 11:40 am
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)
yes...
March 15, 2010 at 11:31 am
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...
March 15, 2010 at 10:43 am
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...
March 15, 2010 at 10:28 am
you can use a case statement in the ORDER BY clause:
ORDER BY
CASE
WHEN <something that makes the first row first>
...
March 15, 2010 at 10:22 am
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...
March 15, 2010 at 9:56 am
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...
March 15, 2010 at 9:42 am
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...
March 15, 2010 at 6:35 am
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";

March 14, 2010 at 8:38 pm
Viewing 15 posts - 9,841 through 9,855 (of 13,469 total)