Hello,

By "disable" do you mean you denied access for the BUILTIN\Administrators login?

If you are also a member of BUILTIN\Administrators then the deny would override the grant associated with your...

Hello Phil,

That's right, if you are using SPs (as opposed to Selects directly on Tables or Views) then you need to grant execute permission on the SPs.

Personally I would create...

Hello Phil,

You will need to add a SQL Server Login for 'DOMAIN\WEB-SERVER$'' or add it to an appropriate Windows Group that already has a Login on the SQL Server. It...

Hello,

That would include the Minutes as well.

Regards,

John Marsh

Hello,

To answer your questions:-

1) Windows Integrated Security is more secure e.g. passwords are not saved in connection strings.

2+3) If you want to specify access to only certain tables then consider...

Hello,

The code below also works.

Regards,

John Marsh

Declare @TestDate DateTime

Set @TestDate = Convert(Char(13), GetDate(), 121) + ':00:00'

Select @TestDate

Hello Again,

The first version is more valid as you need to create a complete SQL statement. You can not create partially dynamic SQL as in your second version.

Below is a...

Hello.

With dynamic SQL you have to build a valid Create table or Select statement in a variable (in this example @sql).

The easiest way to see if it is valid is...

Hello,

You could use dynamic SQL to build the Create Table statement, including the DatePart function to extract the mmyy of GetDate().

Regards,

John Marsh

Hello Again,

Thinking about it, you could do the between on the Week-Number easier than the Start and End dates. You would also need to include the year though (please see...

Hello Glen,

I guess then Start and End dates of a single record extend across multiple weeks?

In that case, you could create a "Weeks" table containing the Start and End...

Hello,

Not sure if I've understood your question correctly, but using a standard "Between X and Y" in the Where clause gets the records of interest and then using a "Group...

Hello,

To be honest, I prefer to use DB Roles for this.

You can create two DB Roles, assign whichever permissions you like to each one and then add the users...

Hello,

I presume you are creating a permanent table rather than a temporary one? I guess you have a reason for that.

You can specify the schema name when you create the...

Hello,

Does this problem happen every time or is it just a one of?

If it has just happened once then may be check the account under which you are linking e.g....