Right click the folder, properties, select security. Look for the account or a group.

http://technet.microsoft.com/en-us/library/cc757520%28WS.10%29.aspx

blandry (4/20/2011)

---

I think what you and Andy are doing is simply great. I am a little confused because your mentoring web says that you are taking only SQL professionals...

Gus has a good explanation. shared locks are compatible with other shared locks. It's exclusive locks that block, or Intent Exclusive locks.

You can see lock compatibility here: http://msdn.microsoft.com/en-us/library/ms186396.aspx

CirquedeSQLeil (4/15/2011)

---

Jeff Moden (4/10/2011)

---

How about spending more time and dollars on really cool stuff like designing a 350HP engine that gets 50MPG without batteries? You see that kind of...

It's not clear what you mean with your backup schedule. You need to specifically state when you have an NT backup running and when you have a SQL backup running...

OCTom (4/19/2011)

---

I don't know about blogs. I think if they're not damaging someone, you'll be OK. I was told recently by a head hunter that I should not be on...

Craig Farrell (4/19/2011)

---

I recently approached my current HR department about blogging. There is an official policy: Mention you work for us, here's your pink slip. It's primarily so...

First, backing up to the network is not recommended. You usually want to back up locally and then copy to the network.

Second, permissions on a drive/folder is a Windows function,...

Apologies, I think this is it: http://www.red-gate.com/products/sql-development/sql-source-control/assets/video/2011-03-29%2016.02%20SQL%20Source%20Control%20Webinar%207%20_%20Continuous%20integration%20for%20end_to_end%20database%20development.wmv

Use Performance Monitor/ System Monitor, set up a trace that counts the number of users. For DML, you can get batch requests, which is likely close, but depending on the...

Part of your restore process will have to add the users back to the database.

Note when you start in single user mode and log into the SQL Server instance, you need to use a Windows Administrator account and you need a single connection application....

These are old views, for compatibility purposes. Don't use them.

sysusers has been superseded by sys.database_principals (http://msdn.microsoft.com/en-us/library/ms187328.aspx)

syslogins has been superseded by sys.server_principals (http://msdn.microsoft.com/en-us/library/ms188786.aspx) and sys.sql_logins (http://msdn.microsoft.com/en-us/library/ms174355.aspx)

Logins exist at a server instance...

your code would have to

a) know which value was deleted

b) use something like this:

set identity_insert tb_bill on

insert tb_bill (bill_no, Product_code, Pro_desc) select 3, 'ABC', 'Third product'

set identity_insert tb_bill off

If...

It's not this simple. The more I dig into things, the less I think I understand on memory pressure and the many ways to detect it.

First, if total (what you...