Personally, when I create the database. I will allocated enough space to grow for minimum 3 to 5 years.

However, this database applications already existed and it was the...

I figured out that the DVD software disk was corrupted or error.

I created a simple package that consist of a Script Task connected to Send Mail Tak.

There are three variables:

dtFileDate DateTime 2/17/2012

dtFilePath string...

Hello SSIS Guru,

I am supputing a SQL Developer who run into problems on SSIS package.

The package returned an error (Please see the attachment) when he tried to execute in DOS...

Thanks for you all help.

I found an article in this forum that posted by Steve Jones.

http://www.sqlservercentral.com/articles/SQL+Server+2008+R2/70092/

Yes, there are several Microsoft SharePoint user groups out there when I seached in GOOGLE.

But not sure which SharePoint User Group is reliable sources and provides Microsoft Best Practice.

Thanks,

Edwin

Thanks for your kind information. I'm very appreciated.

Hi Jeff,

Thanks for your time and explanations on this issues. I am much appreciated.

-Edwin

Thanks. I figured out on the File Connection Source that I need to enter quotation mark.

Thanks for your time and help.

I tested your TRIGGER and it worked on AdventureWorks database.

My scenario is like this:

I created a “Marketing” database.

Then, I created several login and granted one...

Hello,

Can you explain your database replication environments?

Are you setting up PULL Transaction database replication with a remote distributor or

PUSH Transaction database replication with local distributor?

Thanks,

Edwin

This specific SQL Server 2008 located in non trusted network segment.

He used SQL Server Management Studio.

I selected those script, copied and paste into my Microsoft SQL Server Management Studio.

Then, I changed two parameters:

@BackupServerNameInput VARCHAR(50) =...

I downloaded a database backup script from this links

http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/69022/

My test computer has the following environment:

Computer Name: xServer03

Database Instance : xServer03\ALG

Backup folder: D:\Backup

I modified those script on:

...

Hello Steve,

Yes. There are many database backup scripts and I run into errors.

I create a job that runs on Daily at 3:00 AM and step is

BACKUP DATABASE Operations

TO DISK =...