Viewing 15 posts - 826 through 840 (of 1,157 total)
Ninja's_RGR'us (9/9/2011)
MysteryJimbo (9/9/2011)
Ninja's_RGR'us (9/9/2011)
So once ";" are mandatory, the problem will go away.
I love this proposed new "feature". Millions of lines of code to be changed =...
September 9, 2011 at 9:27 am
Ninja's_RGR'us (9/9/2011)
So once ";" are mandatory, the problem will go away.
I love this proposed new "feature". Millions of lines of code to be changed = Unlikely to...
September 9, 2011 at 9:14 am
It behaves the same for user procs too, you can execute a proc singularly without the execute key word. Put another one in and boom!
September 9, 2011 at 9:03 am
FWIW I can reproduce but I dont think its necessarily a bug.
The first query appears to be starting a transaction named sp_who2.
The last one appears to have a problem with...
September 9, 2011 at 9:01 am
GSquared (9/9/2011)
On the original question, are you looking to ask questions or answer them? That is, are you giving an interview or are you being interviewed?
Oooo I never thought...
September 9, 2011 at 7:31 am
Personally, if you dont know about a subject enough to answer the interview questions I'd prefer you said so in the interview.
I dont want to hire someone who has mislead...
September 9, 2011 at 6:25 am
@SQLFRNDZ (9/7/2011)
Intension is how would I detect the re-initialization...
September 8, 2011 at 2:25 am
You could include a post snapshot script to reapply the triggers and any depandancies.
http://technet.microsoft.com/en-us/library/ms188413.aspx
sp_changepublication
post_snapshot_script
September 7, 2011 at 12:24 pm
You will have to change the publication (article) and stop the article behaviour of dropping the object upon reinitialisation. This is the default behaviour for all new articles.
http://msdn.microsoft.com/en-us/library/ms175980.aspx
pre_creation_cmd -Pre-creation...
September 7, 2011 at 11:38 am
If done correctly, those skipped commands should be clean up as part of the distribution clean up job as they no longer fit into the transaction sequence.
September 2, 2011 at 8:09 am
Tables are logical entities within a database and its files, as are their relationships. Relationships are more like enforced rules. The closest thing to "physicality" are the magnetic...
September 2, 2011 at 2:29 am
We wont necessarily wait for SP1 but will have to run it on a dev system for a few months first.
September 2, 2011 at 2:26 am
Something like this.
DECLARE @Fanout int
DECLARE @FunctionID int
SELECT @Fanout = fanout -1, @FunctionID = function_id FROM sys.partition_functions
WHERE name = 'function'
SELECT sp.Partition_Number, sp.rows, '< ' + Cast(spv1.value...
September 2, 2011 at 2:24 am
MyDoggieJessie (9/1/2011)
No problem! I sincerely hope the tsql code helps.Like yourself, I haven't dove in to the powershell much yet...
No better time to learn!
September 2, 2011 at 2:18 am
Googling shows this.
http://support.microsoft.com/default.aspx?scid=kb;en-us;913817
September 1, 2011 at 9:08 am
Viewing 15 posts - 826 through 840 (of 1,157 total)