You need to fill the t-log so it rolls over to the beginning of the file,

so you may have to perform the shrink a couple of times.

Thats why this...

To make it easier for yourself use object aliasses in your queries and the JOIN syntax.

It differentiates join and where clause.

[Code]

Select e.name,

S.name,

C.name

from Employee E

inner join State S

on S.Id...

Thank you for pointing to that Wilfred.

The data is in a consistend state at the standby database, so data is available.

I've tested a snapshot scenario, and it got me totaly...

e.g.

List Installed Software

http://www.microsoft.com/technet/scriptcenter/scripts/apps/user/usapvb06.mspx

There is no move of the datafiles at alter database time !

With Tempdb, your need the alter database to update the catalog

and you'll need the stop/start to create the...

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