just my 2 ct.

I've read somewhere (cannot recall where, but I guess it was in one of Jeff Modens replies) that sqlserver may also experience problems when using between with...

- apparentley you are using SSMS to try to restore the dbs.

It will use the connected instances service account authority to query the backup locations.

With sql2005 that access is restricted...

Indeed, but some people prefer using...

- another reason why it is not a good idea to apply changes without proper inventory and preparation.

You can off course aways generate and execute the sp_refreshview yourself ...

e.g.

Declare @ColName...

the last step of your backup jobs are performing xcopy dos commands to the appropriate safezone.

Because a logbackup may get started while a full backup job is running, that might...

investigate the \hotfix folder for messages. I know this is a struggle, but you'll find what went wrong.

- double check your network guy is "sysadmin" for your sqlserver instance(s) as...

another reason to have the backup files in another folder may be your "copy to safezone" software.

In the past, some of these used to put a folder-lock when they were...

Can you provide sqlserver version info (including buildnumber / sp / CU )

With sql2000 there is een issue when your sqlserver service account is not member of the local admins...

Nice proc.

In SQL2005 access to the errorlog are restriced.

Because some of my developers "realy" needed errorlog info, I've come up with this alternative.

I just import the errorlog using a...

If this is a one shot conversion or operation, you may want to add a computed column to the table

alter table [yourtable] add CompCol_TheSum as (isnull(colA,0) + isnull(colB,0) + isnull(colC,0))

This would be one of the typical cases where a CLR function may help out.

And chances are it will outperform any tsql solution to do the same check/transform.

First have a...

just my 2 ct.

Maybe this little thing can get you on track.

http://www.sqlservercentral.com/scripts/Miscellaneous/31808/

I urge you to read BOL or Gails article.

This is a question that returns very frequent in the forum(s).

As always I'll provide the script from MS. Don't just run it,...

partitioning ?

- Think parallel IO

- limited scan (partition scan) if needed

- alligned indexes (i.e....

Indeed, but that also goes for a "regular" course.

How many times did one...