Viewing 15 posts - 2,731 through 2,745 (of 7,502 total)
Chances are you will get errors if you just perform "select * from table".
This doesn't mean you will not be able to pull data from that table.
Try to put the...
October 21, 2010 at 2:03 am
Paul White NZ (10/20/2010)
WayneS (10/20/2010)
@paul-2 - interesting colours on your new avatar.Thanks - it's almost summer here, so I felt like brightening it up a bit 🙂
I tought it was...
October 21, 2010 at 2:00 am
If an activation sproc is modified, and ssb notices that, it will put a notification in sqlservers errorlog.
Off couse, this does not cover for the generated dynamic sql.
This message will...
October 20, 2010 at 2:48 pm
it depends ....
have a look at Dissecting SQL Server Execution Plans
http://www.simple-talk.com/sql/performance/execution-plan-basics/
October 20, 2010 at 2:43 pm
GSquared (10/20/2010)
Jeff Moden (10/19/2010)
Steve Jones - SSC Editor (9/21/2010)
Paul White NZ (9/21/2010)
The current SQL development model is to address a small number of main product features in each new major...
October 20, 2010 at 9:04 am
CirquedeSQLeil (10/19/2010)
October 20, 2010 at 1:03 am
Does the SQL errorlog mention any changes to the sproc have been detected after the queue start ?
That's how it indicates it isn't using the latest version of your sproc.
Could...
October 20, 2010 at 12:21 am
sqldba_icon (10/19/2010)
Can we do it without exec plan? it has some confidential data, i will try to modify and put it here. Thanks
As Leo stated, a sqlplan will not reveal...
October 20, 2010 at 12:13 am
Please post sqlexecution plans of both queries (saved from SSMS .sqlplan files) as attachment of your reply.
Can you also post the ddl of your view ?
October 19, 2010 at 3:04 pm
ref: http://msdn.microsoft.com/en-us/library/ms190411.aspx states:
Every record in the SQL Server transaction log is uniquely identified by a log sequence number (LSN). LSNs are ordered such that if LSN2 is greater than LSN1,...
October 19, 2010 at 2:06 pm
- Is there a print statement in your SSB procedure ?
- Is there a select statement in your SSB procedure that doesn't return its result to a variable ?
October 19, 2010 at 1:58 pm
jcrawf02 (10/19/2010)
...but SQL prompt saves me from that because now I just fully name everything. ....
That's very handy when you restore a db on the same server, using a different...
October 19, 2010 at 8:02 am
Did you ever find a solution for this issue ?
October 19, 2010 at 7:36 am
Brandie Tarvin (10/19/2010)
Brandie Tarvin (10/19/2010)
GilaMonster (10/19/2010)
Help me do the impossible: http://www.sqlservercentral.com/Forums/Topic1006743-357-1.aspxAdded in a second penny. Hopefully that'll equal two cents worth.
And he seems to have responded well to all our...
October 19, 2010 at 6:49 am
A "maintenance plan" can produce sqlserver backups, but there's more to a Disaster Recovery Procedure than just a valid backup.
Search SSC for "Disaster Recovery planning" and it will come up...
October 19, 2010 at 6:12 am
Viewing 15 posts - 2,731 through 2,745 (of 7,502 total)