Sourav (9/1/2009)

---

1) Can you let me know the process: how SQL Server internally manage the Deadlock?

2) Is it required to free the deadlock manually?

3) What is the way, SQL...

generic questions without assuming anything about the meeting or...

not quite sure what you are after, you mention a automated checklist,...

Omar halwagy (8/31/2009)

---

i have add a database role and then choses and from the securables tab i assigned a spesfic table to deny insert

then go to user on the...

Well for a start, if you change...

Steve Jones - Editor (8/28/2009)

---

There definitely seem to see more jobs in the BI sector, especially SSIS in the US. Not sure about the UK.

I think anything you can do...

just out of curiosity, does this happen if you create the login and the user, using t-sql rather than through the gui. and do you have any triggers setup either...

Is it just me or do the same people constantly ask the most basic questions almost on a daily basis, which they could answer themselves in minutes by either google...

RTaylor2208 (8/27/2009)

---

Hi,

I know that this site is for MS SQL Server but I am in a bit of a rut, I work for the scottish health service and through all...

thierry.vandurme (8/27/2009)

---

total memory is 8Gb. SQL instance 1 is using about 7.5Gb of it. I suppose if we add memory it would even grow so can I assume the server...

bit slow this morning, but apart from that ok. i would look at your network

kiranmca24 (8/27/2009)

---

Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53

Cannot insert the value NULL into column 'owner', table 'tempdb.dbo.#spdbdesc___________________________________________________________________________________________________________0001000000DA'; column does not allow nulls. INSERT fails.

The statement has...

thierry.vandurme (8/27/2009)

---

Hi all

we have a server running two SQL 2005 instances (Standard edition). At the time of installation noone bothered to configure the min/max memory settings. Now, of course,...

Thanks very much, you missed the 1 in front of the 326 but that is ok 😉

WAGalaxy (8/24/2009)

---

Hello

For business requirements I want to create another sysadmin account called "sa2" and give it to the Software Developers/Business Analysts to use so they can perform their duties. What...