Hi,

Thank you for your response.

I didn't alter anything from your script, just copy, paste and execute it.

I'm using SQL server 2008 R2 and Outlook 2007. My outlook is able to...

Hi Brandie,

Thank you for your response.

Those errors are coming from SQL logs, so there should a way to extract them using SQL query. This is what I'm looking for.

Thanks.

- Peter

Hi,

Thanks for the script, it's a great work for sharing 🙂

When I run the script and an email has been sent out to my inbox, but its content all in...

Hi,

Thanks for the query.

Had run the 1st query and based on the info from the 1st query, executed the 2nd query on my secondary DB, but it hit with some...

Hi All,

I've managed to solve the questions that I've posted earlier.

Thank you for your help and support.

Have a nice day.

Bye

Hi Eirikur,

Thank you very much for your response and help.

It had cleared my doubt and the given article is very useful.

If it's not too much too ask, would like to...

Hi Eirikur,

declare @TableSpace table

(

TableName sysname

, RowsK varchar(32)

, ReservedMB varchar(32)

, DataMB varchar(32)

...

Hi Eirikur,

Thanks for your response and help.

It works fantastic, really appreciate for your kind help.

I'll need to perform further testing with other sample data.

Thanks.

Hi Eirikur,

Thanks for your response and help.

Should it be something like this statement?

INSERT INTO @tab1

SELECT t1.name, t2.name

FROM sys.tables t1

INNER JOIN sys.schemas t2 ON (...

Hi Experts,

In brief, could anyone help on how to use these commands "sp_MSforeachtable" and "sp_spaceused" to check only for certain tables only, for instance: EMP001, EMP002, EMP003, EMP004, EMP005 ?

Appreciate...

Hi Eirikur,

Thanks for your response.

I've checked the given URL and it's not what I'm looking for as it's checking for all tables.

What I want is to check for certain tables...

Hi Experts,

Anybody can help?

Thanks.

Hi,

I'm using MS SQL 2008 R2.

Please advise how can I temporary disable log shipping without damaging the current log shipping setting or process?

Which option should I use?

Thank you.

- Jack

Hi Vegard Hagen,

Great. Thanks for the advise. 🙂

- Peter

Hi Gurus,

I've 1 more query. Sorry 🙂

For instance:

-> restore log Database name from disk='c:\PATH_Tlog2.trn' with norecovery

-> GO

Is there a way to put 'restore log' and 'GO' together in 1 line?...