From Books online:

[ @username = ] 'username'

The username to use to log on to the e-mail server. username is nvarchar(128), with a default of NULL.

[ @password = ] 'password'

The...

If you lookup 'sp_addsubscription' in books online, you will see that there are the parameters@frequency_type, frequency_interval, @active_start_date and @active_start_time_of_day.

These will create a schedule when to start replicating and how...

The short answer is yes, you can run x32 and x64 instances next to each other.

But you cannot upgrade a 32-bit instance to 64 bit.

You need to install...

There are a couple of things you should check.

First can you send a testmail using DB Mail by right clicking on DB Mail?

If yes, check if SQL agent is configured...

Mani (11/12/2008)

---

Hi All,

After i installed the named instance , strangely when ever i try to enter any of the virtualservername\instancename for the "remote computer option" it is giving me a...

You cannot restrict which client application is used to send a restore command. All you can do is control who has permissions to do a restore. By default only sysadmins...

You cannot add transaction log backups to a full backup of another database!!!

Why can't you simply script the schema changes you've made in development and deploy those scripts to production....

If xp_cmdshell is enabled on your server you can use it to get a list of files from your directory first and storwe the names in a (temp) table.

Something like...

Could you explain a bit what you mean by "unnecessary restoration" ?

Are you looking for object level restore options or what?

Mirroring simply replicates all (logged) transactions on the mirror database.

Since switching partitions is logged in the transaction log I don't see any reason why this shouldn't work.

The reason for this issue is that when you restore a database to another server it keeps it original collation. Now then stored procedures or other processes make use of...

The failover time depends on the number of transactions which need to be rolledback or forward and the time it akes to start up all the services. 6- 10 minutes...

You can use SELECT INTO to create a copy of your original table using the same datatypes.

So in your case to create an empty table do

SELECT TaskTitle as TempTitle

INTO...

I think the best option in your case is to create two groups. One group with select\update\insert and delete permissions and another one with only select. Then add the users...

This script might not include exactly the columns you're looking for but it should help to start you up. Ideally replace GETDATE() at the end with some variables and use...