Viewing 15 posts - 36,436 through 36,450 (of 39,720 total)
I'd worry that something popped up a dialog. Can you send other mail? Maybe the outlook startup is looking for a profile?
If it won't kill, then you probably need to...
March 19, 2003 at 9:39 am
Do not set IDENTITY INSERT ON and don't insert anything for the recordid.
Steve Jones
March 18, 2003 at 10:11 am
This is actually pretty simple. SQL Server stores it's name in master.dbo.sysservers using the entry that is set as local to respond to (in addition to localhost and (local) ).
connect...
March 18, 2003 at 10:09 am
If you selectively turn off some queries, then you start to lose the benefits of query plan caching. I would think that you would want to build separate queries and...
March 18, 2003 at 10:00 am
March 17, 2003 at 11:06 pm
Write a procedure to disconnect people when the sysprocesses.lastbatch is over 15 minutes.
Schedule this to run every xx minutes.
Steve Jones
March 17, 2003 at 3:27 pm
Haven't seen that one. I'd guess you may need to call MS on this one.
Steve Jones
March 17, 2003 at 10:01 am
I'm guessing that it isn't completing correctly. Does the stored procedure work and complete if you run it in query analyzer?
Steve Jones
March 17, 2003 at 9:37 am
That's the simplest method (above) with a cursor.
Steve Jones
March 13, 2003 at 9:40 am
That's because there is no fatal error, so isql exits correctly.
I think you would need to trap the error and drop it into a table. Then query that table from...
March 12, 2003 at 10:46 am
March 12, 2003 at 10:45 am
a hint
select
getdate()
, datepart( wk, getdate()) 'this week'
, datepart( wk, getdate()) - 1 'this week'
, datepart( dw, getdate()) 'day of week'
You want to work on the week # being one...
March 12, 2003 at 10:44 am
Is there some reason you cannot break it into multiple steps? Seems like it would be good programming practice to do this anyway.
Then scheduled multiple steps.
Steve Jones
March 12, 2003 at 10:37 am
That basically means all the pages are contiguous in the system.
Steve Jones
March 12, 2003 at 10:04 am
THat's part of the forum code (Snitz) that we used. It doubles quotes for the inserts into the table to be sure they work. I suspect they forget to undouble...
March 12, 2003 at 9:26 am
Viewing 15 posts - 36,436 through 36,450 (of 39,720 total)