Just wanted to mention that this error shows up when...

When I was first learning SQL, I had to google a million things a day. I actually still do look things up, every single day without fail.

Answers to this kind...

The one data file per cpu rule of thumb mostly applies to TempDB.

I'll address that first....It is typically not a good idea to have the tempdb data files and log...

If you do SET ROWCOUNT ON before you run it (which is the default..so as long as you don't set it to Off), it should display the number of rows...

Hah 🙂

Actually ninja's code was very good...I've never really had a case where I needed to use reverse(), but now I bet I can find some. I had always just...

Try this:

DECLARE @STR VARCHAR(250)

set @STR = '\\IP_Address\DirName\DirName\DirName\twProcessDB_20100819173001.trn'

SELECT LEFT(@str, LEN(@str) - CHARINDEX('\', reverse(@str), 1))

This gets everything up to the last \ in the string.

If all the SP does is update the table, why give them access to it in the first place?

Check the ANSI server settings

edit: This is weird and I think there's some missing info. Can you post a screenshot of both results please?

Perry Whittle (8/19/2010)

---

SQL_Padre (8/19/2010)

---

I am need of some advise. I have a 3 node cluster, 2 Active one Passive. Server boxes have 48GB RAM, each SQL instance Min/Max...

Whoops, my fault.

That was supposed to be FROM DISK not FROM FILE

Not nearly enough caffeine yet today..sorry about that.

Setting up the cluster in 2008 is almost identical to 2003, except that a few names are changed and moved around.

You still create an empty group, add disks to that...

So are you trying to just restore a copy of the DB onto this server from the backup?

If so and you already created it with the data files in the...

Unfortunately this isn't possible.

You can run the command:

DENY VIEW ANY DATABASE TO [login]

But that will hide all databases besides the ones that that user is the owner of (actual db...

Have you tried just using a linked server instead of openquery? They are handled differently by the engine.

Open the Failover Cluster Manager

Right click Services and Applications -> More Actions -> Create Empty Service or Application

Name it whatever you want, add your disks, then install SQL to it.