Maybe the account that runs SQL SERVER agent doesn't have enough priveleges....

Or you are using the wrong account there ???

Maybe the account that runs SQL SERVER agent doesn't have enough priveleges....

Or you are using the wrong account there ???

Thanks Antares,

I looked in the books as well (First thing I do) but i couldn't find anything...

I was wondering... So I decided to post this question. And the answer is...

Antares are you telling me that a UDF doesn't store a execution plan ?????

That implies that you must never use data retrieval functions in a UDF ...

Am i wrong here...

The function is a lookup in anotjer table and returns a Table

Thanks crosspatch i know that one from the BOL. ( I wished every programming book would start with that phrase )

But the real question is WHY is it slower,...

Are the Default timeout settings on the server the same ????

I know this all.

But look at the following code....

DECLARE @STARTTIME DATETIME

DECLARE @ENDTIME DATETIME

DECLARE @LOOP AS INTEGER

DECLARE @MAXINSERTS AS INTEGER

DROP TABLE TESTTABLE

CREATE TABLE TESTTABLE

( --ID UNIQUEIDENTIFIER DEFAULT NEWID(),

ID INT...

Detach the database.

delete the log !

Next attach the database with

sp_attach_singel_file_db !

Is this the case for every database or only a specific one ?????

In other words is the backup failing just for this database or for all databases.

You should do this. Look in BOL for Service accounts.

You could need it for :

·Remote procedure calls

·Replication

·Backup to Network Drives

·SQL Mail

·Linked Servers

If you use log shipping it doesn't matter what you change ( add tables, add filegroups etc....) as long as Both systems have the same drive topology.

Tested it and works...

Andrew,

Why not create a Maintenance plan that does them all.

Or do you want to back up the databases simultaniously ?

Because if that is what you want You should create...

Not So difficult i think.......

every time you execute the job store the month in a table. For example Months.....

then you could do the following ....

if datepart(dw,getdate()) = 1 (is a...

I Agree with Carl. Most of my speed improvemnets was moving the small resultset to a amemory table and then join that large resultset with a small memory table,

or...