Thank you both for your input

George, I think at this stage I will just monitor the logfile VLFs and if these grow in number will take the action that you...

one other related question:

because the log file has grown from 500Mb to approx 14Gb in 500Mb increments, the number of virtual log files is approx 250.

Should the number of...

Thank you both for your input - I will take a look at the link you posted John.

There is plenty of disk space, so that's not an issue. The mirroring...

here's an even simpler query that those i've seen posted - but no doubt i have overlooked something 🙂

CREATE TABLE #Test

(ID...

are you right-clicking on the individual object such as a table, a stored proc etc, or on the database itself? If you right-click on the database and go to Tasks...

just been to see "Revolutionary Road" - quite good, but pretty angsty

best movie i've seen for a while was "The Illusionist" (2006) - captivating movie with a great ending...

the worst...

this may be of use (posted previously on another thread), using FOR XML:

http://www.sqlservercentral.com/Forums/Topic616796-1291-1.aspx#bm618171

🙂

check out my reply in this thread - it may be helpful:

http://www.sqlservercentral.com/Forums/Topic616796-1291-1.aspx

Try using FOR XML PATH and creating an HTML table for the data.

Here's some code that I use to report the status of scheduled jobs that ran the previous day....

we had a similar problem when we added additional memory to one of our SQL Servers. Even when SQL itself was limited to 8Gb, the problem continued and this caused...

Also, take a look at FOR XML PATH and formatting query results into an HTML table. I have several scheduled jobs set up that use this method of extracting and...

I have implemented something similar using a linked server to AD

Step 1: Create a linked server to your Active Directory:

sp_addlinkedserver 'ADSI'

, 'Active Directory Service Interfaces'

, 'ADSDSOObject'

, 'adsdatasource'

Step 2: Create a...

...also, for example, you may be running Active Directory (AD) on a separate server, and if you have a need to import records from AD (like records of staff members)...

I suspect that "shouting" is not likely to help anyone...

That's cool Jack - and bass guitarists are musicians - its just drummers that don't qualify for that title *L*

:w00t: only kidding.... in case any drummers are reading this...:P