i am getting out of memory pop ups and there are many ad hoc queries running on the server.

The only solution seems to be restarting the server, but IT IS...

Physical RAM on the box = 24 Gb

MAXmemory allocated to SQL server = 20 GB

Min memory to sql server = 512 MB.

Still SQL server is freezing.

SQL Surfer '66 (10/2/2015)

---

Did you set the type to WMI event alert? I don't know much about WMI namespaces. I use the type SQL Server Performance Condition Alert instead, which...

SQL Surfer '66 (10/2/2015)

---

One way is to create an alert in the SQL Server Agent with the type SQL Server Performance Condition Alert. Set the Object, Counter, Instance and type...

it is a indexed table.

That is what i need.

I want the caller(particular user/goofy) to be able execute this SP.

I have created a sql login [goofy] with securityadmin previledge.When i log in as...

hello,

I tried it but not working.

Basically I have a SP that checks for a user in the user databases and if it is not there it creates it with db_owner...

Dear Mr.Ajay,

Did you finally find the solution for your trigger? i myself am in need for the same.

I have created the trigger for CREATE db but not for restore and...

Thanks guys, especially Lowell for the code snippet.

Actually I need, when a user creates/restores a database on the server

he should be automatically be assigned to db_owner role.

Thanks...

I have a similar question.

I tried creating a partition on a table in sql server 2008 R2.

But i do not see the storage option when i right click the table.

Then...

Thanks a lot..i will take it from here..thanks once again

Sorry to say this..I am new to SQL...what is BOL? can anyone provide me with a query as a solution