Did you try this:

ALTER PROCEDURE [dbo].[myStoredProcedurel]

(

@StartDate AS DateTime = NULL

, @EndDate AS DateTime = NULL

)

AS

BEGIN

declare @refStartDate datetime

declare @refEndDate datetime

Set @refStartDate = isnull(@StartDate, dateadd(ms, -3, dateadd(mm, datediff(mm,...

you are using a windows domain account, right ?

- You'll have to define the alert "with log", because if a user raises the error using "with log" (s)he must be member of sysadmin :ermm:

- you may have to...

Atul DBA (11/24/2009)

---

I disagree with Stev. We can take the backup to other disk if they are accessible by SQL Server resource list.

This is highly possible in stand alone servers....

I would stick to using the UNC path so any investigating DBA will immediately recognize the backup is being taken at the other physical location.

backup yourdb to disk="\\theotherserver\abackupshare$\yourdbFULL.bak"

off course you can add the extra case to evaluate the > 1000.

Keep in mind to actually evaluate on one of the join condition key columns of your B table....

at least go for 3th or 4th NF to understand the data and its relationships.

Stick with that as long as you can. (i.e. unless it is proven to be less...

- if the service account of the source server has write authority at the target servers backup location, you can initiate the backup to that location without a problem, or...

select a.col1, isnull(b.colX,1) as colX

from myobject a

left join myotherobject b

on b.fkcol = a.keycol

have fun .

No, it wasn't me.

Because this shrinking of tempdb frequently...

as stated in all kb stuff already pointed to, you cannot shink tempdb without stop/start of the sqlinstance. (an even if it would succeed, chances are your ongoing operations may...

If your sql2000 instance is still available, just script out all jobs, alerts, user created objects, ....

and then run that script on your sql2008 instance.

Keep in mind NOT to implement...

IMO these are very interesting articles on this Disk related subject ...

- Playing with Disk Alignment

http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/11/19/playing-with-disk-alignment.aspx

- SAN Performance Tuning with SQLIO

http://sqlserverpedia.com/wiki/SAN_Performance_Tuning_with_SQLIO

IMO these are very interesting articles on this Disk related subject ...

- Playing with Disk Alignment

http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/11/19/playing-with-disk-alignment.aspx

- SAN Performance Tuning with SQLIO

http://sqlserverpedia.com/wiki/SAN_Performance_Tuning_with_SQLIO

IMO these are very interesting articles on this Disk related subject ...

- Playing with Disk Alignment

http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/11/19/playing-with-disk-alignment.aspx

- SAN Performance Tuning with SQLIO

http://sqlserverpedia.com/wiki/SAN_Performance_Tuning_with_SQLIO