Indeed.

Also keep in mind functions are directly available to any sql statement, not only from within a stored procedure.

Also keep in mind you need to provide the actual schema...

There is an issue with sql2000 linked servers (sp3 and sp4) when called from sql2005.

KB ref at http://support.microsoft.com/default.aspx?scid=kb;en-us;906954

Did you apply at the sql2000 side ?

IMO it is best to switch the approle immediate after the connect.

This way you'll not forget to code it before you execute any db requests.

Keep in mind, approles are...

Fraggle (9/7/2008)

---

It has always been my policy to used functions to replace repetative coding. Why do I need to continually type to code out to verify that a customer...

there is a Template.ini file on your install dvd.

It describes all parameters.

You may come up with something like this:

; C = Software X = data

; IMPORTANT: THIS IS A...

check for SQLServer Migration Assistant for Oracle.

(there is a sql2005 and a sql2008 version)

free download at http://www.microsoft.com/downloads/details.aspx?familyid=6D9BC6A7-75DA-493E-BEE5-50F4A4352B91&displaylang=en

just my 2 ct

You can connect using the actual instance port number, so my guess would be you...

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 ] )...