Here is a KB article describing what the BUILTIN\Administrators login is:

http://support.microsoft.com/kb/263712

and here is a blog post about removing the group (which is a bigger deal on 2000 and 2005):

http://www.mssqltips.com/sqlservertip/1017/security-issues-with-the-sql-server-builtin-administrators-group/

To review...

If you guys have room next year I would love to play in the league!

Thanks for the article Dwain! Always looking for better ways to get things done.

Hi Dan,

First I would suggest that you create unique SQL accounts (or even NT accounts) for systems to access your server. Most things that are connecting to your server does...

There are too many variables in a restore to say "that you should experience a 2 x backup time for you restore time". Your backup is backing up 8k pages...

Welcome to the forum. First off please read the article in my signature about posting questions to the forum. I have done the DDL and insert statements for you and...

Have you tired creating a trigger and it isn't working or are you looking for someone to provide you a complete trigger? These forums are usually to help people with...

Have you tired creating a trigger and it isn't working or are you looking for someone to provide you a complete trigger? These forums are usually to help people with...

In you query you are starting with 5/24/2013 20:00:00, but when you call the stored proc you are using 00:00:00. Change the call to the sproc to use 20:00:00 and...

You can download it from MSDN as long as you get the standard edition. It isn't a different version from the one on the installation media (expect that you can...

I'm still not sure what exactly you are looking for since you gave us only 3 days of data, but want WTD, MTD, QTD, YTD etc. In you expected output...

I'm sure someone here has a cleaner solution but this should work:

DECLARE @WeekNum INT = 47

DECLARE @FirstYear INT = 2012

Declare @SecondYear int = 2013

SELECT convert(varchar(10),DATEADD(WEEK, @WeekNum - 1,DATEADD(dd, 1 -...

Generally it is a good idea to index your FK columns, but I suggest that you test before and after applying your changes. You need to be aware that performance...

jervyn_almanon (11/20/2013)

---

Thank you Sir for the replies I appreciate it a lot.

I am clueless sir where and what to study first I'm currently reading an ebook on "How to be...

Please also provide some sample data (as insert statements) and the expected outcome of your query.