Viewing 15 posts - 36,496 through 36,510 (of 39,771 total)
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
Why can you not use the UPDATE() statement. I'd be really wary of having a trigger that did not know the columns of the table.
You can always get the columns...
March 11, 2003 at 9:45 am
tough questions, lots of responses.
Basically, identity is simpler, easier IMHO for humans to deal with. Less space. Not unique across servers. Can cause issues in replication.
GUID is harder to use...
March 11, 2003 at 9:42 am
Are you guys running a dedicated SAN for the database server? Or is it shared?
Wondering becauase we are getting a SAN to remove some file server storage and they are...
March 11, 2003 at 9:39 am
I believe any change to the login (new defaultdb, language, etc) will trigger a chance on xdate2. However, once the login is setup, it is unlikely that anything other than...
March 11, 2003 at 9:36 am
I've automated the sa change. As far as service accounts, I change those manually. Since I need to restart SQL, might as well watch each one.
As far as EM, up...
March 10, 2003 at 3:57 pm
This is an intersting question and one I may dive into with an article. Basically, I'd be watching for any error and resolving it or determing the cause. Most information...
March 10, 2003 at 10:08 am
I've gotten the 2K-2K to work, but not 7 to 2K.
The stored procedure is intended to move logins, not permissions, though I agree with you that adding permissions would be...
March 10, 2003 at 10:05 am
I had a meeting with the Litespeed guys and they are working on a GUI to go with their product. Expect to see pre-release (beta) code anyday.
I wouldn't let the...
March 8, 2003 at 9:59 pm
I have also used views for this.
use databaseB
create view TableInA
as
select a.*
from databaseA.dbo.TableA
Steve Jones
March 7, 2003 at 11:56 am
Viewing 15 posts - 36,496 through 36,510 (of 39,771 total)