Good article,

I agree with the post as far internal systems are concerned, far too many people place far too much importance on their own 'babies' be that software, databases or...

Thanks bnordberg, thats just what I was looking for!

I found passing bulk data as XML (text) to a stored procedure as an ntext parameter, then use OPENXML to pass data into table variables\temp tables much easier than creating your own sql...

Thanks for the reply, I dug a little further and found the KB article related to this problem. I was adding the correct flag but also require the server name...

Yeah I started using that to give me a transactions per day, but after a trawl through numerous web pages and groups discovered this wouldn't be particularly accurate.

Thanks

Chris

Thanks David,

I think I'll go for the PRO SQL Server 2005 book for starters, then go for individual books you suggested as an when needed.

I have the Inside SQL 7.0...

Thanks Mark

I think you'll find that the author wasn't comparing Bill Gates with Hitler but emphasising the sometimes hysterical condemnation of the Slashdot crowd of people like Bill Gates.

It is not good...

Give this a go

select  rsn.MemberID,

  b.ResJoinID,

  b.Reason,

  b.ChangeDate

from SAVA.SAVA_SAVRSN rsn

inner join

 (

  select distinct

    a.ResJoinID,

    c.Reason,

    (

     select max(ChangeDate)

     from SAVA.SAVA_SAVDJN

     where ResJoinID = a.ResJoinID

   &nbsp as ChangeDate

  from SAVA.SAVA_SAVDJN a

  where a.ResJoinID = 2

&nbsp

Good grief, I didn't expect that!

My original post was not intended say theory (or fundamentals) are not important but that the question itself was poorly worded, and in the wrong...

Is it possible we can have all questions and answers in English please, or atleast in a language that google translator can handle. 🙂

Thank you

Is the transaction log backed up to a different physical disk or even better to an independent storage area (NAS, tape for instance)? If this is so once you have...

Create an operator (SQL Server Agent\Operators). Under the Notifications tab you should see a number of Alerts relating to replication.

These alerts can be sent as Emails, Pager or Net Send.

Cheers

Chris

I wouldn't recommend autoshrink as this could happen at inconvenient times of the day, killing performance. You could setup a SQL Agent job to run DBCC SHRINKFILE at a period...

Apart from checking EM\Management\SQL Server Logs and/or EventViewer\Application Log, you could also configure notifications for system alerts (or your own custom alerts). You can do this via EM\Management\SQL Server Agent\Alerts

Cheers