Sql Managment Studio will not let you directly manage or work on 6.5 databases.

After a search of support.microsoft.com it seems that you cannot upgrade the database. This is probably a...

balbirsinghsodhi (4/16/2008)

---

There is some process which fills up the space on C drive at particualr time and then releases it.

Is there a way to check what is that process. ?

I...

Kevin (4/15/2008)

---

Hi

If you are considering a dedicated server to be a file server for your backups, also take the following into consideration:

* is this server going to be in the...

John Beggs (4/16/2008)

---

Peso (4/16/2008)

---

As for your original question:

It depends on which line of CASE statement get evaluated first.

Since the two lines returns different datatypes (line 1 varchar, line 2 int)...

I believe this has to do with the link server. It's the link server driver that is returning the error and then disconnecting the connection. You can test this by...

Thanks for the reply. Yeah, i had to resort to a RPC call using openquery. The link server then used the where statement and passed back the appropriate records. I...

max (1/14/2008)

---

hi,

i recently joined a company as dba. there is a job step which executes a storedprocedure for database maintenance purpose. but when i went into database and tried...

Oops. I meant that field to be employee id and so is needed in the query. I'm trying out your query. Thanks!

This does not give you the physical count, this gives you the logical count only. Just fyi.

If you have hyperthreading (rare these days) and/or dual core systems, they would double...

Hmm. Not sure if we're talking about the same thing, but the original article refers to software(?). IE Downloading a ISO image of Windows 2000 Server from MSDN(very legal) and...

Woo!! I never knew WinRar wors on ISO! Sweet! another great use for my favorite zipping utility!! thanks for the tip!

Thanks Mark. So if I understand you correct, i should have the SAN broken up into various smaller sizes. ie. for us, we're using 72GB drives and so what 36GB...

We are having similiar problems with our HP/Compaq san. 

Mark,

-----Use Load Balancing software like power path to distribute the traffic over the HBA's.

You are referring to the software that comes from...