duplicate post

replies here please

http://www.sqlservercentral.com/Forums/Topic1327733-391-1.aspx

You will need to modify all sub level folders to not inherit permissions from the root directory, That way you add permissions to the folders you want them to...

Force of habit...

I had a couple of pints of St Austell's Tribute on Saturday, that was a good tasting ale

http://www.staustellbrewery.co.uk/beers/cask-beers.html

Old Empire is a great favourite of mine, can remember a night at uni where 10 pints where consumed in the space of around 3-4 hours. They where the...

No, thats right, 0 means midnight, 1 means 1 second past midnight

As its an INT column 000000 shortens down to 0.

Google has plenty on the topic,

but this should start you off on your search

http://msdn.microsoft.com/en-us/library/ms365937%28v=sql.105%29.aspx

All user databases use the Model DB as their template, so if Model is in FULL recovery the DB will be created in FULL recovery unless you issue an ALTER...

select @@max_connections

sp_configure 'user connections'

Possible to do in the query.

Take a look at the SUSER_SNAME(), SUSER_NAME(), USER_NAME() functions which you can pass in as the where clause and filter on the credentials column.

I take it these are the ones you are talking about?

http://www.sqlservercentral.com/articles/Reporting+Services+%28SSRS%29/69257/

What is the configuration?

1 instance 2 nodes

2 instances 2 nodes

etc etc

What nodes are the instances running on in Failover Cluster Manager?

What node where you running SSCM on?

GETDATE() returns a DATETIME value which rounds to .000 .003 or .007 of a second.

I would look at rowversioning using datetime2 and timestamps

http://msdn.microsoft.com/en-us/library/ms182776%28v=sql.105%29.aspx

Are you running SSCM on the active node?

The first link contains the T-SQL to create the alert and the job and the table it logs it too, but you will need to specify the Database and modify...