If it is SQL Server Express Edition, the TCP/IP connection type may not be turned on by default. To check, go to Start > All Programs > find the...

To accomplish initial requirement, try this:

USE dbname

GO

SELECT 'GRANT EXECUTE ON ' + SCH.name + '.' + PRC.name + ' TO [someuser]' AS Permission

FROM sys.schemas AS SCH

INNER JOIN sys.procedures...

I have posted this previously to this website, but I've made a few enhancements to it, so I'll post it again. This is my script to run a Security...

For each location, it is usually once a year. They are not on-going, in the sense of college courses or continuing education courses, that may meet daily or weekly....

Yes, I've been to several. They are very informative and a lot of fun. I spoke at one in 2010. That was my first major speaking engagement....

Check out http://www.sqlsaturday.com. SQLSaturday is a whole day (obviously, on a Saturday) of free training in SQL Server, and is held in many cities across the world....

No, that is correct. I create an AppReader role, and grant SELECT to each table to that role.

For the AppUser role, I grant INSERT and UPDATE to each table...

Here's one way to do it. Try this code and modify to fit your needs.

CREATE Table DimDate

(DateKeyintNOT NULL

CONSTRAINT PK_DimDate_On_DateKey PRIMARY KEY CLUSTERED,

DateToUseDatetimeNULL,

CalYrMthintNULL,

CalYrintNULL,

CalMthintNULL,

CalDayintNULL,

EngDayOfWkvarchar(10)NULL,

DayNumOfWkintNULL,

DayNumOfYrintNULL,

WeekNumOfYrintNULL,

EngMonthNamevarchar(12)NULL,

CalQtrintNULL,

CalYrQtrintNULL,

CalYrHalfintNULL,

CalYrSemesterintNULL,

FiscalQtrintNULL,

FiscalYrintNULL,

FiscalYrQtrintNULL,

FiscalYrHalfintNULL,

FiscalSemesterintNULL

)

GO

CREATE NONCLUSTERED INDEX NI_DimDate_on_DateToUse ON DimDate(DateToUse)

GO

CREATE NONCLUSTERED INDEX...

The page size is 8k, because that is the maximum size of a record in SQL Server (8096 I believe). However, when data is read, it is read in...

What is a schema-wide permissions?

GRANT UPDATE ON SCHEMA Production

This is a schema-wide permission. You have granted update on all tables in this schema to someone (need a "TO...

You are wanting to do schema-wide permissions? If that is true, it is not to the best practice of "least-permissions", only giving them permissions on the objects they need....

Don't know if this will help, but see this link for a script I wrote for creating an instance audit documentation script. If you set the @outputtype variable =...

In case this helps anyone, here is how I do in-SPROC logging. In addition to the normal stuff, I also log the input parameter values that are sent to...

Here is the url to a script I wrote to do a full instance security audit. It gives all permissions for each database.

http://www.sqlservercentral.com/Forums/Topic1226870-359-1.aspx#bm1230153

Maybe it will help.

I had the same issue recently, so I wrote the following script. It assumes the first column is the PK, so you can change the logic if that is...