Hi opc.three

Well, i started to back up all the databases since i did not get any backups since sat. I am using SSMS and if the DBCC CHECKDB fails on...

Hi Andrew

thanks for the link

I found additional links in case someone else has questions:

http://blogs.msdn.com/b/sqlblog/archive/2006/10/06/msdtc-and-sql-server-on-a-cluster.aspx

What is MSDTC used for?

SQL Server 2005 requires MS DTC in the cluster for distributed...

Thanks Paul

I am never confident applying anything from Microsoft, especially hot fixes

Even they are not confidnet when they tell you to be cautious

I guess I will forego this one for...

Hi Paul

here is the info on the sql server from 1-12-13

I am using SSMS maint plans to back up databases right now

Does that use vss writer service ?

I looked at...

Thanks Scott

i think tis is a product for securing and protiectin documents

I need the opposite to get rid of them

Jim

Thanks Gail

I did nolt think it was going to be easy

This sounds like SharePoint is going to be a problem when it comes to deleting the files

Jim

Thanks Lynn

Jim

I am on 2005.

Will this not work then ?

Jim

ok got a little farther

no idea what this means:

declare @idxname sysname;

set @idxname = 'idx_DatePosted';

declare @idxname sysname;

set @idxname = 'idx_DatePosted';

declare @SQLCmd varchar(max);

select @SQLCmd = stuff((

select 'union all' + char(13) + char(10)...

Hi Lynn

receiving this error executing the code:

HResult 0x8B, Level 15, State 1

Cannot assign a default value to a local variable.

Msg 137, Level 15, State 2, Server NSAB-SS80-SQL-N, Line 5

Must declare...

Hi roryp 96873

never heard of quotename

will look into it.

Thanks

jim

Hi roryp 96873

I had to modify the code as it does not like '-' in the database name so i bracketed them. I also concatenated the database name to...

Hi Kingston

'

even though thi seeems to run, it is geberating an error

Thanks

Jim

1> IF OBJECT_ID('tempdb..#tmp_Indexes') IS NOT NULL

2> DROP TABLE #tmp_Indexes

3>

4> DECLARE ...

Thanks Kingston

I will take a look see

Jim

Thanks very much roryp 96873

i will give it a shot

Jim