tried a new backup yet?

works for me in sql 2000.

dbcc traceon (3226)

go

sure u don't have it off in startup param?

is this the blog entry u r talking about?

remember that rpc virus a few years ago? it had that 60 second countown then would shut down the pc. one night the network guys worked all night to...

how does server2 connect? needs domain credential i believe

don't think it can be done (short of editing a backup of msdb with a hex editor). may try opening ticket with MS PSS team.

thanks. now if i could just figure out how to see all the threads i posted to that have recent replies.... 😀

ps. u dont think i'll get to 100 posts?...

tried creating alias for each other in sql configuration manager?

made sure the xml is good?

have network admin make certain that user permissions are not set to read only on drive

u will need to modify if multiple data files. also note that maxsize and growth are in 8kb increments, so need to multiply by 128 to get mb. but, the...

-- this will get u started --

SET NOCOUNT ON

Create Table #t (

db varchar(255),

filename varchar(255),

name varchar(255),

int,

maxsize int,

growth int

)

Declare @db varchar(255)

Declare c Cursor

read_only

for

select name from sysdatabases where dbid >...

SELECT t1.*

FROM T1

LEFT JOIN T2

On T1.partID = T2.partID

And T1.SellerCountryCode = T2.SellerCountryCode

WHERE T2.partID is NULL

besides which, celko is provably wrong.

identity fields often make the very best candidates for primary keys in terms of performance. and they certainly don't taint the natural design of the...

technically ReportServer and ReportServerTempDB are user databases.

sorry, forgot distribution which is also system db

the real problem is that you are storing dates in character data types. else all values are already in the same format. should store dates in smalldatetime or datetime...