Viewing 15 posts - 36,166 through 36,180 (of 39,717 total)
I would have expected this as well.
Oh well.
Steve Jones
June 19, 2003 at 10:07 am
eljeffo,
apologies if you didn't like the responses. We do moderate some posts if we think they are flames. Keep in mind your post is kind of "in your face" and...
June 19, 2003 at 10:00 am
Try
select
a.*
from tablea a
left outer join table c
on a.col1 = c.col1
where c.col1 is null
Might not be...
June 19, 2003 at 9:54 am
maybe a rename? That REALLY screws up master servers and one reason why I don't use them.
Steve Jones
June 19, 2003 at 9:52 am
create procedure MyProc
@empid int
as
select * from emp where empid = @empid
Steve Jones
June 19, 2003 at 9:45 am
Why do you need to insert a where clause into the view? Define the view without it and insert the where clause into your query of the view.
Steve Jones
June 19, 2003 at 9:43 am
June 19, 2003 at 9:39 am
course you have to have the trace running. If you want to do this, set this up in a stored procedure, mark as a startup procedure, and then monitor and...
June 19, 2003 at 9:31 am
Or it could be coding errors or network problems. I've been running XP, as are some others here and while we don't constantly make ODBC connections, I use QA, which...
June 19, 2003 at 9:26 am
There might be a script in the library here, if not it's easy to write. Setup a stored proc to scan sysprocesses and check the last batch against the current...
June 19, 2003 at 9:24 am
Are the master and targets at the same SP/patch level? Check @@Version.
If you can't delte them from EM, use QA and whack them from msdb..sysjobs and msdb..sysjobsteps.
Steve Jones
June 19, 2003 at 9:10 am
check what the service is trying to start. Double click it and look for the command line. Verify that the sqlservr.exe application is actually there.
It sounds like someone moved things...
June 19, 2003 at 9:06 am
Redesign is in the works, but it's time consuming, plus we've added so many little features around Snitz that a bunch of stuff is breaking when we move.
Actually poor...
June 19, 2003 at 8:57 am
Salary is a funny component. Everyone wants to know, no one (usually) wants to say what they make. Not that I care too much about people knowing my salary, but...
June 18, 2003 at 11:20 am
That will work. You also do not need to use the encrypted string. If the SQL Agent account has rights, you could just schedule the job with DTSRun (see BOL...
June 18, 2003 at 11:11 am
Viewing 15 posts - 36,166 through 36,180 (of 39,717 total)