Viewing 15 posts - 11,041 through 11,055 (of 13,469 total)
ALTER PROCEDURE [dbo].[sp_AppendToFile](@FileName varchar(255), @Text1 varchar(255)) AS
DECLARE @FS int, @OLEResult int, @FileID int
EXECUTE @OLEResult = sp_OACreate 'Scripting.FileSystemObject', @FS OUT
IF @OLEResult 0 PRINT 'Scripting.FileSystemObject'
if that is your whole proc, it's...
June 3, 2009 at 8:15 am
david.ainsworth (6/3/2009)
Thanks for any advice in advance.
I have a SQL server I wish to replace and it has a legacy Stored Procedure that gathers information from the database and...
June 3, 2009 at 7:24 am
you are right.
compatibility mode has nothing to do with how the native mdf or backups are constructed...it only decides what syntax for TSQL will be permitted to hit the database...that...
June 3, 2009 at 7:13 am
ALZDBA (6/3/2009)
Attached you'll find a version I use for quick and dirty CPR-trace 😉
ALZDBA the version you posted has all the CrLf stripped out, making it difficult to test, since...
June 3, 2009 at 6:43 am
you didn't explain what the issue is.
is it you need to populate a table with each hour? you said "update" the table, not populate, so i'm not sure where the...
June 2, 2009 at 5:46 pm
excellent point Jan,
it seems to me that if the "global" table is missing a column , it's gotta be because a different process created a table with the same...
June 2, 2009 at 8:44 am
if you are sending the email as HTML, then that is the expected behavior...HTML does not respect extra whitespace ,tabs, or CrLf; it only recognizes it's markup tags.
if you do...
June 2, 2009 at 5:30 am
ahh you are right Greg, i did not notice that. Thanks for the better solution.
June 1, 2009 at 4:36 pm
the trigger fires one for any statement which affects the table; as a result, any statement you write inside that trigger must plan on updating/inserting multiple rows. it CANNOT assume...
June 1, 2009 at 3:11 pm
ok here's a best guess;
the execution plan has a portion of the query in it..something like the first 4200 characters or so, so i didn't have all the joins...i inveted...
June 1, 2009 at 8:54 am
##Errors is a global temp table...the two pound signs make that global instead of just for your proc.
a global temp table is visible to all other processes that might need...
June 1, 2009 at 6:38 am
Scott Coleman (6/1/2009)
We now now a unique constraint won't work for the Customer table - they're all named John. :w00t:
lol:
(IS for brothel)
i saw that too, and was wondering...
June 1, 2009 at 6:25 am
save it as a SQLplan...that's just xml. you can throw it in a zip file , and then attach it here to a followup post.
when we open it in SSMS,...
June 1, 2009 at 6:22 am
Rob SQL2008 has an actual CPU governor for that situation...preventing any one query frome ating all resources...it's not in 2005.
a 20 minute query is unusual, unless you are threshing thru...
June 1, 2009 at 6:17 am
ahh you changed it on me since i posted....
i would switch tou using the row number function then...see how this works for you.
run the inner query so you can see...
June 1, 2009 at 6:08 am
Viewing 15 posts - 11,041 through 11,055 (of 13,469 total)