Viewing 15 posts - 61 through 75 (of 643 total)
ggoble (4/23/2014)
How does this script handle multiple files and filegroups?Edit: Does this script handle multiple file and file groups?
Yes. It handles multiple file & filegroups.
Here is an example for you...
April 24, 2014 at 3:56 am
JoseM (4/22/2014)
The only thing I miss is a parameter to change the destination database name.
In our case many customer has a mirrored database in the same...
April 22, 2014 at 5:46 am
Kurt W. Zimmerman (4/21/2014)
April 21, 2014 at 2:30 pm
JCAirey1 (4/21/2014)
Cool script. What happens if @AutoExecute AND @IncludeSystemDatabases are both equal to 1? 🙂
Hi JC,
In case @AutoExecute & @IncludeSystemDatabases both are set to 1, procedure will throw following error:
"AutoExecute...
April 21, 2014 at 2:20 pm
Perry Whittle (4/21/2014)
Why not just use log shipping, seems it would be perfect for this scenario.
Thanks for your comment Perry.
You are absolutely right. Log shipping is also a very...
April 21, 2014 at 7:44 am
Due to some formatting issues in the article, RESTORE HEADERONLY & RESTORE FILELISTONLY commands are not visible in full.
Complete commands are given below:
Restore HeaderOnly:
RESTORE HEADERONLY FROM DISK = 'D:\SQLTestLab\Backups\AdventureWorks_FULL_2014_04_03_18_11_23.BAK'
Restore...
April 21, 2014 at 4:59 am
Steve\Gail,
I have written something on it. I may submit it today. You can check if it is good to publish.
P.S.: Like everybody else on SSC, I would always be interested...
April 17, 2014 at 3:49 am
Hi Steve,
Are you asking for an article on Point-In-Time recovery or is there anything more than that?
April 13, 2014 at 2:59 pm
yuvipoy (4/7/2014)
Divine Flame (4/7/2014)
I am not sure if this syntax is supported yet:
SELECT * FROM TableName WITH (DEADLOCK)
"DEADLOCK" is not a recognized table hints option in SQL Server.
So which database...
April 7, 2014 at 9:44 am
yuvipoy (4/7/2014)
Those are the existing codes.i need to modify them.
Yes using dead lock will lead to incorrect reports.
:hehe:
I am not sure if this syntax is supported yet:
SELECT * FROM...
April 7, 2014 at 8:18 am
selvakumar.sms (3/12/2014)
I restarted SQL Server Agent also.But no luck.
As per your error description it seem that the mail account used to send the mails doesn't have the permission on the...
March 12, 2014 at 5:16 am
kbhanu15 (3/12/2014)
hi,for sample example i given this tamp table and sample results.
the original query is different in my project.
any other way to avoid this index scan.
i need solution for issue.
Thanks
Bhanu
Considering...
March 12, 2014 at 5:09 am
selvakumar.sms (3/12/2014)
SMTP Server IP is configured in Database mail Account.but mail is not delivery.Any services i need to enable in the server ?From other server Database mail is working.
Ensure you...
March 12, 2014 at 4:39 am
selvakumar.sms (3/11/2014)
Hi,Server dont have SMTP serivce and IIS.
Is SMTP and IIS is mandatory ?
Thanks
You need to ask your system or network administrator about the SMTP...
March 12, 2014 at 3:42 am
You may need to put it like this:
with cte as
(
select userid, parentid from user_detail where userid = '100002'
union all select t.userid, t.parentid
from ...
February 24, 2014 at 4:24 am
Viewing 15 posts - 61 through 75 (of 643 total)