That can't be possible since you were able to run DBCC MEMORYSTATUS

I believe it must be, that and...

Let's start with the first section, I'd like to...

Hmm... I'm no expert in this, but you may want to look at DBCC MEMORYSTATUS

deep_kkumar (6/6/2012)

---

I am getting this error on one of the production servers. All the jobs are failing because of this error. Version of sql server is 2008 sp3.

I have checked...

SQL_Surfer (6/6/2012)

---

I need to drop a table that is used in replication (from sqlserver 2005 to 2008). And recreate the table with some column changes. I cannot drop the table...

pveilleux (6/6/2012)

---

SQLKnowItAll (6/6/2012)

---

pveilleux (6/6/2012)

---

SQLKnowItAll (6/6/2012)

---

If someone is a sysadmin, they are automatically in all fixed database roles. They have full access. You could add an SQL Agent role,...

pveilleux (6/6/2012)

---

SQLKnowItAll (6/6/2012)

---

If someone is a sysadmin, they are automatically in all fixed database roles. They have full access. You could add an SQL Agent role, or take...

DBCC SHRINKFILE only shrinks files if there is available space. It is not a magic compression tool.

Also, run this and tell me what happens:

declare @x int, @z int

SELECT @x

SELECT...

If someone is a sysadmin, they are automatically in all fixed database roles. ...

Lynn Pettis (6/6/2012)

---

SQLKnowItAll (6/6/2012)

---

hehehe... I would take then off of the join condition as well, it...

hehehe... I would take then off of the join condition as well, it confuses me to...

Well then, post the actual code.

DBA_SQL (6/6/2012)

---

My CSV file is of "|" limiter. I am trying using the following BCP command but receives error.

SET IDENTITY_INSERT table1 On

DECLARE @cmd nvarchar(500)

SELECT @cmd = 'bcp slcdb.dbo.table1 ...

sqlfriends (6/6/2012)

---

SQLKnowItAll (6/6/2012)

---

it grants the user the proper permissions by assigning it to a "virtual user" within SQL Server. The user itself does not have to have an...