Viewing 6 posts - 46 through 51 (of 51 total)
There's a pretty cool tool made by Red Gate Software called SQLCompare. It's pretty handy for stuff like this since you may have the same table with the same column...
March 11, 2004 at 7:06 am
I recommend checking out the [SQL Books Online] for DB_NAME.
Cheers,
Ken
March 11, 2004 at 7:00 am
Rob
Check out the SQL Books Online for DECLARE (as in DECLARE @mytab TABLE...) and SELECT TOP n (re: your requirement of selecting only certain dates)
Cheers,
Ken
BTW: I recommend in-memory tables for...
March 11, 2004 at 6:56 am
If you're looking for version info, try http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=26 and look for version.sql
I'll have an update shortly.
Cheers, Ken
January 28, 2004 at 9:41 am
Check out http://support.microsoft.com/default.aspx?scid=kb;en-us;272683
Evidently you can run:
RESTORE DATABASE DatabaseName WITH RECOVERY
to pull a database stuck in a load state. (Apologies, I haven't done this myself.)
Just a suggestion: you...
April 28, 2003 at 6:48 am
Viewing 6 posts - 46 through 51 (of 51 total)