Why would you want to use a function if you can do a join ?????

Most of the time it's these kind of functions that mess up response times in your...

Maybe this one can help you:

CREATE PROC spc_ALZDBA_check_failed_jobs

@NumDays int = 1,

@RecentOnly char(1) = 'n',

@Job_Name varchar(132) = Null

AS

begin

-- example: sp_ALZDBA_check_failed_jobs 5,...

I think you can create a snapshot database, and make a backup of that.

TEST IT - TEST IT

/* Database Snapshots */

CREATE DATABASE Adventureworks_ss1430

ON (NAME = AdventureWorks_Data,

FILENAME = 'C:\Backups\AdventureWorks_data_1430.ss')

AS SNAPSHOT...

you may want to read Jeff Modens "Tally table" article.

In sql2005 you can use ranking functions. Check BOL.

If you have heavy disk activity, it may be your extending tempdb-process that gets a timeout, resulting in the errormessage you've seen.

As already stated, tempdb is one of the working...

For the moment we are using vbscript to gather WMI information.

You may as well put that into a clr module and get your info that way.

Keep in mind you'll need...

X64 is not Itanium, but is 64 bit.

64-bit can directly address way more than 16Gb http://techreport.com/articles.x/8131/2 or http://en.wikipedia.org/wiki/X86-64

Thats why you don't need to enable AWE anymore on 64-bit.

You need to...

you could deny a user access to a table using:

DENY { ALL [ PRIVILEGES ] }

| permission [ ( column [ ,...n ] )...

There are articles at SSC regarding db ownership.

e.g. http://www.sqlservercentral.com/articles/Advanced/understandingobjectownership/1966/

We don't use sa for login, but have all databases owned by sa.

All sysadmin stuff is being performed using our windows-admin-accounts. (dbas...

You could offer the dba a weeping tissue because he's the one messing up. They will have to modify their code.

As already stated : If you want order, you need...

MS has released a Upgrade assistant for Access.

(free tool)

http://www.microsoft.com/sql/solutions/migration/access/default.mspx

Warren Peace (9/5/2008)

---

OK, I'm a litle stumped here. I have installed SQL 2005 on an Itanium build and I have set the RAM to use a boatload of ram 8192MB...

As usual, security has been optimized in sql2005 !

For a proc to work in a database context, it needs to be in that database,

except for procs (residing in master...

- How big is your transaction log file ?

- what's the growth size for the log file ?

- is...

Everything will still work, but will only use a single db-thread to accomplish the queries.

So it may need more time to complete, but your error will nolonger occur.

You may want...