Viewing 15 posts - 36,256 through 36,270 (of 39,810 total)
Don't use the wizard. It's a piece of #@$%#%$#
http://www.sqlservercentral.com/columnists/ckempster/deattachandreattachdatabases.asp
http://www.sqlservercentral.com/columnists/rsharma/copydatabase.asp
Steve Jones
June 19, 2003 at 10:18 am
Droppinbg back a bit, my tax rate is US 35% (my wife works), not sure about the state rate in CO. Hell, I'm not against taxes, they allow me to...
June 19, 2003 at 10:14 am
Not that I know. The only way I've found is to use an Active X Task to call the sproc and then alter the package dynamically or use the Active...
June 19, 2003 at 10:09 am
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
Viewing 15 posts - 36,256 through 36,270 (of 39,810 total)