Viewing 15 posts - 391 through 405 (of 2,463 total)
mpradeep23 (1/25/2013)
is thier any performance issue by creating tables and sp s in model database
No
January 25, 2013 at 5:11 am
surilds (1/25/2013)
It would be better if you have queries for past run queries?
i dont think it would be available everytime , it solely depends on plan cache.
January 25, 2013 at 5:08 am
try this
SELECT
‘SESSION_ID: ‘ + CAST(es.[session_id] AS VARCHAR(4)) + ‘ ‘ +
‘ HOST_NAME: ‘ + es.[host_name] + ‘ ‘ +
‘ PROGRAM_NAME: ‘ + es.[program_name], ‘ ‘ + CHAR(13) + CHAR(10),
‘...
January 25, 2013 at 4:59 am
Dave Hall (1/25/2013)
I'd love to Bhuvnesh but I'm using SQL 2000 🙁
oh my bad i just realized that i am in sql 2000 window :Whistling:
January 25, 2013 at 3:30 am
Dave Hall (1/25/2013)
I'm calling the 1st Proc like before and the transaction errors are gone (yay) BUT the Delete statement still executes and is not rolled back (boo).
Then i...
January 25, 2013 at 3:24 am
Also see this link too http://rusanu.com/2009/06/11/exception-handling-and-nested-transactions/
January 25, 2013 at 3:14 am
Instead , why cant you use SET XACT_ABORT ON in both the SP and remove all explicit transaction handling
January 25, 2013 at 3:10 am
padhu.mukku (1/24/2013)
Try to use Table variale
Depends.... if you are using heavy volumne data and you would be using same resultset in later part of SP too (in JOINs...
January 25, 2013 at 12:16 am
January 25, 2013 at 12:12 am
January 25, 2013 at 12:11 am
deep.tkt (1/24/2013)
If we use rebuilding clustered indexes to move objects between data file what is impact where there is 100GB clustered index ?
there are couple of things yoou...
January 25, 2013 at 12:09 am
arthi.anan (1/24/2013)
So when i login with 'empdbo', i'm able to access 'emptest' db. This should not be allowed.
'empdbo' will be sysadmin thats why it can access anything in that...
January 24, 2013 at 11:49 pm
This document talks about replication and database mirroring (including information on trace flag 1448 which allows the log reader to replicate changes regardless of the mirroring state):
January 24, 2013 at 11:23 pm
Viewing 15 posts - 391 through 405 (of 2,463 total)