Seth Lynch (9/17/2009)

---

Hi

When deciding on disk size on a server do you use any formulas for disk size.

I will have 3 disks one for data one for logs one for...

Dean Jones-454305 (9/17/2009)

---

Hi Guys

I used to have a tool which once installed will scan the network for all SQL isntallations, informs you of the hostname, IP address and what version...

Correct - you should not have a null value for the object id unless you're in the wrong database or have a typo in the schema/object.

1. DBCC INPUTBUFFER()

2. You can use profiler to capture all queries by that spid

3. http://www.sqlservercentral.com/articles/DMV/64425/

kumar99ms (9/16/2009)

---

Hi Experts,

I have to move Primary file group table to another(user defined ) file group could you any body help me

Really appriciated. Those guys.

Am using alter database move...

luckysql.kinda (9/16/2009)

---

I am getting null value for following object and many other objects as well (Not for all). The object resides at Adventureworks database.

select object_id('person.document')

Can anyone tell me why this...

luckysql.kinda (9/11/2009)

---

I am from a small company. My location is changed and I am given the authority to set up all the new sql server installation and all. This is...

Depends on the size! If they are big, a backup/restore with something like...

:laugh:

Huh??

Tara (9/9/2009)

---

yes that is what my script does in the 4th part for which i am not worried but i would like to know how can i implement forst 3...

Tara (9/9/2009)

---

I have a script which i want to run from the same stored procedure which locks some tables in the database which contians sensitive data.

Can you let me know...

Hello,

Yes, you can do this from a stored procedure. Will require a bit of dynamic SQL, but it can be done.

Don't quite understand what you mean in point 4,...

Quick google search on sql server virtualization would be a good start.

I also have a pdf which I can send over if you drop me an email address...

It depends! Lots of variables in your question.

We do use VM for some SQL Server databases but they are low in load. It was a consolidation exercise to...