Viewing 15 posts - 3,046 through 3,060 (of 7,168 total)
Perry Whittle (9/25/2012)
opc.three (9/25/2012)
The SpaceUsedMB could be low if you ever switch the DB into the Bulk Logged Recovery Model and perform any minimally logged operations.
Yes, but bear in mind...
September 25, 2012 at 6:23 pm
Ah, courses and not exams. I would take the 2008 course if you have no choice to take the 2012 course. There are hardly any features available in 2008 that...
September 25, 2012 at 4:58 pm
It depends on what you're intending to support after passing the exams but I would go for the 2012 exams at this point.
September 25, 2012 at 4:45 pm
Think of the overhead you'll be asking every other developer that work not only on this package, but also others that need this same checkpoint-like behavior. It's going to become...
September 25, 2012 at 4:25 pm
sanjuv999 (9/25/2012)
please guide me
Do not enable xp_cmdshell! You do not need it for this scenario and it introduces risk in your environment.
If you want to do everyting with T-SQL use...
September 25, 2012 at 4:20 pm
I would grab a copy of XML Spy and try mapping it. It's a pretty robust tool and could probably get you your XSLT pretty fast.
September 25, 2012 at 4:13 pm
CREATE TABLE #LOGSPACE
(
DB SYSNAME,
LogSize FLOAT,
SpaceUsed FLOAT,
Stat BIT
);
INSERT INTO #LOGSPACE
(
...
September 25, 2012 at 4:04 pm
No need for an extra step really, if all you want to do it restart that step should it fail. In the job step you can set the Retry attempts...
September 25, 2012 at 3:55 pm
GilaMonster (9/25/2012)
opc.three (9/25/2012)
My only point was that being a member of sysadmin does not imply there is a user in the db_owner Role named 'sa.'
No, there doesn't have to...
September 25, 2012 at 12:21 pm
I am still unclear about your concern. In the data? Or in between the markup tags?
Like this:
<root><element>1
2
3</element></root>
Or like this:
<root>
<element>123</element>
</root>
September 25, 2012 at 12:12 pm
GilaMonster (9/25/2012)
opc.three (9/25/2012)
GilaMonster (9/25/2012)
Any member of the sysadmin role has all permissions across the instance, is implicitly db_owner of all databases and cannot be denied anything.
To be clear sa is...
September 25, 2012 at 11:58 am
XML is not format dependent. Any whitespace produced in between markup is strictly for us humans. All XML parsers are going to strip that out (i.e. ignore it). What are...
September 25, 2012 at 11:41 am
I haven't used it so am not sure it fills all your requirements but it sounds like using a Multi-server Agent Job may work for you:
September 25, 2012 at 11:40 am
sestell1 (9/25/2012)
opc.three (9/25/2012)
GilaMonster (9/25/2012)
Any member of the sysadmin role has all permissions across the instance, is implicitly db_owner of all databases and cannot be denied anything.
To be clear sa is...
September 25, 2012 at 11:16 am
Perry Whittle (9/25/2012)
opc.three (9/25/2012)
September 25, 2012 at 10:21 am
Viewing 15 posts - 3,046 through 3,060 (of 7,168 total)