do you have analysis services on this server?

you have to install SQL to a disk that on SAN storage that can be moved or "failed over" to any of the nodes. that way, if there is a...

for the disk you want to install SQL on, be sure you can move the disk resource to all the nodes in your cluster using cluster administrator.

try this...

declare @jobs table(name varchar(50),id int identity)

declare @JobName varchar(50)

declare @max-2 int

declare @count int

declare @sql varchar(5000)

insert into @jobs(name)

--replace next line w/ subquery

select jobname from blah blah blah

select @count = 1,@max= max(id)...

Yes, you could either do a single node cluster, but you would not have failover capabilities.

http://technet.microsoft.com/en-us/magazine/2007.03.sqlclusters.aspx

or you could use virtual servers to do more than one node.

A lot of...

I have .net 3.5 + sp1 and SQLDigger works fine, although it's possible that I installed it before I had that framework installed. I just confirmed that SQLdigger is functioning...

Jobs are also a good place to start, especially if the growth consistently happens at the same time of day. run select * from msdb.dbo.sysjobhistory to see if there was...

I would run sp_who2 while tempdb is growing and that will return all the active processes. if you want to see what statements are being run, you will need to...

I use a free utility called SQLDigger that allows you to search sprocs for a string. You can do a search for the username and it should find any sprocs...

if it's possible, I would look at what is running on the server while the growth happens and you will be able to zero in on the true cause.

temp tables and work tables for sorting also have an affect on tempdb, so if you are using a lot of temp tables, table variables, or doing a lot of...

it's easy to implement. look in books online (help) under the topic "jobs [SQL Server Agent]"

it sounds like you may have an execute as username in a stored procedure or function, and that is why it will not allow you to drop the user.

it means you can only have 2 physical nodes. You can run as many instances as you want on it, but you can only have 2 physical machines in the...

I beleive what it is actually complaining about is that it wants you to use the original column name in the order by and not the alias that is set...