I attached 2 files here

1 is hte execute sql task parameter mapping and

2 are the variables.

Please see in the 2 , the value for dt1 and dt2 , I...

derekr 43208 (12/21/2011)

---

Those options allow for send mail when job...

first configure database mail

then create a sql job

inside job there is an option notifications

write email id in that ...

Regards,

Skybvi

Just wondering, when they will reboot the server,

all the sql services will automatically be stopped and restarted...

Why you need to manually stop the services first then .?

Regards,

Skybvi

GilaMonster (12/12/2011)

---

SKYBVI (12/12/2011)

---

Ya but mostly it will be...

Ninja's_RGR'us (12/12/2011)

---

Except for all the stats that are not...

Firstly do a check db integrity, then do rebuild index

You don't need an update stats if you doing a rebuild index.

Regards,

Skybvi

Note that the VIA protocol is deprecated by Microsoft, and will be removed in a future version of Microsoft SQL Server.

It is however supported in SQL Server 2008 and SQL...

via is supported in sql server 2008 r2 ...

Wrong question/answer

Regards,

Skybvi

Cool

thanks a lot

Regards,

Skybvi

idear 's sql diagnostic manager

http://www.idera.com/Products/SQL-Server/SQL-diagnostic-manager/

Regards,

Skybvi

John Mitchell-245523 (12/1/2011)

---

Like I said, it's pseudo code, so you'll need to check the exact syntax of ALTER LOGIN and the structure of server_principals to see what the column names...

John Mitchell-245523 (12/1/2011)

---

The only way I know for existing logins is to execute the ALTER LOGIN statements one by one. You can generate them very easily something like this...

John, what about If i need to set the policy for all...

If its a 1time thing I would use BCP,

Otherwise SSIS...

@gianluca Yes, 1 lakh means 100000

Regards,

Sushant