Viewing 15 posts - 37,501 through 37,515 (of 49,566 total)
Saurabh Aggarwal (7/23/2009)
do i need to change something in stored procedure ,views etc code also,
Maybe. Are they failing to create too?
July 23, 2009 at 2:22 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic758000-360-1.aspx
July 23, 2009 at 2:21 am
Have you updated statistics since upgrading to SQL 2005? If not, do so and test the query out again.
July 23, 2009 at 2:20 am
Can you post the code that the insert in question is part of?
July 23, 2009 at 2:17 am
FredS (7/22/2009)
I have only a couple tables at the moment. I'm learning, but making mistakes fast and altering table structures will be important.
Look up ALTER TABLE in Books Online.
July 22, 2009 at 1:50 pm
Monica K. Murphy (7/21/2009)
I finally found documentation that verifies that the datapage itself is backed up in the trn log.
That is for bulk operations in bulk-logged recovery only.
If...
July 22, 2009 at 1:50 pm
The definition's fine, just need some sample data. Read this to see the best way to post this to get quick responses. http://www.sqlservercentral.com/articles/Best+Practices/61537/
July 22, 2009 at 1:35 pm
Can you post the current SQL error log? There are a number of reasons why this might be happening, from benign to serious, need to see the error log to...
July 22, 2009 at 1:03 pm
One thing I forgot to ask...
Is this insert the only statement in the transaction, or is it in an explicit transaction along with other commands?
Is there a trigger on the...
July 22, 2009 at 12:58 pm
Have more coffee, it's the answer to everything.
Unrelated...
Does anyone really know their deadlocks well? This one has me stumped (though I admit I have not examined the exec plan in...
July 22, 2009 at 10:37 am
This might help you with the problem that they can pass the parameters or not.
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
Could you maybe post the entire procedure, the table defintions, some sample data and the expected...
July 22, 2009 at 10:23 am
Indeed. However looking I can't see any reason why this is dynamic SQL at all.
This should work just fine
DECLARE @TreatyNumber As Varchar(20)
SET @TreatyNumber = '200704.2.6'
DECLARE @temp_provisions As Table (
...
July 22, 2009 at 10:11 am
Replace EXEC @sql with EXEC (@SQL)
Without the brackets, the assumption is that the content of the variable is a stored procedure name
July 22, 2009 at 9:25 am
The audit login event occurs when someone logs in to SQL. The audit logout event occurs when someone logs out of SQL.
What do you mean by 'affects performance'?
July 22, 2009 at 9:05 am
Viewing 15 posts - 37,501 through 37,515 (of 49,566 total)