Viewing 15 posts - 76 through 90 (of 280 total)
I'll only take on freelance work if I'm certain I can do the job. If there's any areas I feel I'm weak on then generally I'll let the client...
August 8, 2012 at 10:39 am
If you have a process logging in as sa, then for pre-2012 versions you'll be able to lift the sa password from the Win32 MSSQLSERVER (or your named instance) memory...
August 8, 2012 at 10:24 am
Thank you, the timing for this couldn't have been better as I'm looking into Powershell now, it's an area I've been avoiding too busy to concentrate on 🙂 Thanks...
August 8, 2012 at 8:37 am
What method are you using to load the data from the CSV files to your table?
August 7, 2012 at 9:56 am
Call me arrogant but if an interviewer asked me questions which were designed to trick me, or were utterly stupid in themselves, or that were designed to be unanswerable, I...
August 7, 2012 at 9:53 am
Please review the information in http://msdn.microsoft.com/en-us/library/ms345117(v=sql.90).aspx, it provides a good introduction to XML and SQL Server. By following the links you'll be able to see examples of importing XML...
August 6, 2012 at 6:39 am
It sounds like a custom job application technical test, are you able to post the job description for the role you're applying for please? That may shed some light...
August 6, 2012 at 3:08 am
Andy - Brent's script is a good one but the OP should be warned it isn't a catch-all. I used this script once, took note of the recommendations and...
August 6, 2012 at 3:04 am
I'm afraid I have no idea, I'm not a server admin.
August 6, 2012 at 3:02 am
Alerts here -> http://msdn.microsoft.com/en-us/library/ms180982.aspx
Replication here -> http://msdn.microsoft.com/en-us/library/ms151198.aspx
Replication with alerts here -> http://technet.microsoft.com/en-us/library/ms151752.aspx
and here -> http://msdn.microsoft.com/en-us/library/aa237180(v=sql.80).aspx
and here -> http://www.mssqltips.com/sqlservertip/1901/customized-alerts-for-sql-server-transactional-replication/
Hope this helps.
August 6, 2012 at 3:01 am
There isn't a catch-all script, this is something you would normally manage yourself. I use a collection of scripts, some of which I wrote, some I didn't - automatic...
August 6, 2012 at 2:55 am
The transaction log will be kept in check by a regular full backup schedule. If you're using a full recovery model, you should be prepared for a greater transaction...
August 6, 2012 at 2:53 am
This sounds like a bounceback from your mail server, check with your sys admins that you can send e-mail to an external domain.
August 6, 2012 at 2:51 am
I'm a bit of an SSIS n00b but I'm okay with temporary tables, so you'll have to excuse me if I'm totally wrong - but I believe your problem might...
August 3, 2012 at 4:21 pm
Answer is wrong, last query returns an error. Point refund please, my good sir!
August 3, 2012 at 1:50 am
Viewing 15 posts - 76 through 90 (of 280 total)