Viewing 15 posts - 56,176 through 56,190 (of 59,067 total)
Heh... I like it! Simple math... everything in the universe ultimately rounds to zero... with or without bankers rounding!
(Unless you're gonna round...
June 9, 2007 at 5:15 pm
The log file will not grow that large if you do regular backups. Setting a 1 gig log file may cause your server to come to a sudden halt if...
June 8, 2007 at 9:18 pm
Heh... yeah, some naming standards seem appropriate. Don't let them use blanks in their names, either. ![]()
June 8, 2007 at 9:11 pm
Of course, you can still fix it...
QUOTENAME(REPLACE(REPLACE(somecolumn,']',''),'[',''))
June 8, 2007 at 5:38 pm
Aren't you still using the 4 part naming in the dynamic SQL? I don't think that's gonna work unless you try it like this... (although, I certainly could be wrong)...
EXEC...
June 8, 2007 at 4:17 pm
Sorry... just figured out what you're trying to do...
If you call the stored proc in Master from a given other database, then I think you just do the delete using...
June 8, 2007 at 7:28 am
OK, but you need to use dynamic SQL anyway... why temp fate with Master? Create the DBA database and work from there...
June 8, 2007 at 6:39 am
You'll need to use dynamic SQL to create and execute the delete, but I've gotta ask a question...
Your DBA let's you write to the Master database??? Or, if you're the...
June 8, 2007 at 5:25 am
Echo.>>yourfilename simply appends a blank line to your file... Echo. creates the blank line.... ">>" is the old DOS notation for "take the output of the command to the left...
June 8, 2007 at 5:18 am
Moving data from the main database does not shrink the space reserved for the main database... nor should you shrink it unless this is the very first time you've archived.
June 8, 2007 at 5:07 am
Pretty sure that's what it means...
June 7, 2007 at 6:27 pm
Maybe in SQL Server 2005... in 2000 the estimated execution plan show "something" and the actual execution plan shows absolutely nothing.
June 7, 2007 at 4:47 pm
You said the query was throwing an error... probably be helpful if you posted the error message(s).
June 7, 2007 at 4:42 pm
Viewing 15 posts - 56,176 through 56,190 (of 59,067 total)