surya (8/25/2009)

---

First of all thanks for your quick reply.

Exactly now i am trying like that

I have few quries in this

if we give connection string in expressions

by default what connection...

leave 1gb

~BOT

did you look in the last sql log?

probably not much there, but you could see if the SHUTDOWN command was issued

~BOT

same is true with a mugshot table with a personid. No gaurantee that the right person is in there......

Lynn Pettis (8/25/2009)

---

This is the only part I don't agree with and I think there...

use a common table expression, the row_number() function over customerid and orderid, sort by date asc and self inner join on a.rownum = b.rownum-1

~BOT

After re-reading your question I think you might mean that you can't shut down the instance because people are connecting so quickly.

use the shutown with nowait option

http://msdn.microsoft.com/en-us/library/ms188767(SQL.90).aspx

to keep that from...

I think that error is from the 'post update' steps.

I don't usually perform that last step.

If memory serves, SQL2K5 SP3 turns off the SQL Instance when you apply it.

Your database...

gah (8/25/2009)

---

my simple thoughts:

...

single click "subscribe to topic"...without moving off page and this flag then used to

filter "recent posts" options to only display what I have subscribed...

2!!!!

As a rule, I like logs on their own drive and I like tempdb on its own drive.

it really depends on tempdb read/writes, but your doing well by placing the...

Lastly and most cheaply...

download SQL Toolbelt and use SQL Compare to build your schema & assign appropriate security, then use SQL Data Compare to fill up some tables....

I use expressions to change the connection string.

It's super easy with a forEach loop.

Simply assign your resultset to an object variable, loop through that recordset object and assign

each row/column...

This is an indication of NO memory pressure.

SQL Will happily keep taking what the OS will give it.

I think 2GB on a 64 bit system is a little stingy to...

First off, I wanted to say thanks to Steve for providing a resource that can pay us back with career development. I know the few articles I've written...

Try this:

select OBJECT_SCHEMA_NAME(so.object_id) as schema_name, so.name as table_name, si.name as Primary_key_name

from sys.objects so left join sys.indexes si

on si.object_id = so.object_id and is_primary_key = 1

where is_ms_shipped = 0