Viewing 15 posts - 271 through 285 (of 535 total)
switch your recovery model to Bulk logged before the reindex work and then back to full afterwards. then see what the maximum log usage is after that for a...
July 7, 2009 at 6:46 am
you could look at the possibility of logon trigger, where you roll back logins based on the application type. you would obviously have to put some checking in to...
July 6, 2009 at 1:23 am
use SSIS.
use a data flow task to output your query results to file. use a send mail task to attach the file (the csv you just made) to the...
July 5, 2009 at 3:24 am
is the DB that uses windows authentication and the application database the same database?? if so why do your domain users all have full insert/update/delete when you are using...
July 5, 2009 at 3:20 am
do you keep the SSIS packages on the file system or in MSDB? if you keep them on the file system then the modified date of the package will...
July 4, 2009 at 5:44 am
fundemental jobs are your backups and integrity checks, without these your asking for a whole world of pain.
after that you should be looking to introduce index rebuilds/reorganisation, there is a...
July 4, 2009 at 5:32 am
generally if you are asked about that in a SQL server interview/exam you would be expected to know that unix users would need a sql login whereas windows users can...
June 24, 2009 at 9:22 am
you could probably do this through some kind of logon trigger whereby you count the number of current logins and then either roll back the logon if its 20 or...
June 8, 2009 at 10:49 am
karthikaug18 (4/20/2009)
Thanks Gila. but i just want to know how the question will be.
i believe 70-443 is case study based. you get around 7 scenarios each containing around 6...
April 21, 2009 at 1:43 am
parth83.rawal (3/16/2009)
SEND ME MAIL ON parth83.rawal@gmail.com,though i am already having html code but issue only is not able to put image in my HTML.
Just emailed you, let me know...
March 16, 2009 at 6:45 am
I dont believe you can do a case statement within HTML. If you cant implement the solution i mentioned in my last post it might be possible to end...
March 16, 2009 at 5:51 am
im not 100% sure if you can do that kind of thing in HTML code or not. From what i can tell you are trying to return some kind...
March 15, 2009 at 2:41 pm
rar!! can someone tell me how to post HTML code without it removing all the tags...please? 🙂
March 15, 2009 at 10:32 am
yes you can show images in your HTML emails. Do you want to post the code you have so far. Is the SP failing to execute or are...
March 15, 2009 at 10:25 am
rollback is the same in sql
Begin transaction
'Do your stuff
Rollback Transaction
There are a couple of ways you can check for errors
The old school way is to check for errors after each...
February 28, 2009 at 3:18 am
Viewing 15 posts - 271 through 285 (of 535 total)