It's on the "Choose Script Options" in the Generate script wizard. The defalt setting is "Script Drop False".

If anyone knows a way to change the defaults I would be very...

Have a look at this script http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1350

But be aware, in order to read the eventlog, the account under which SQL server runs must have permission to read the eventlog....

Since I stated this post some time ago I haven't spend too much time on it. Basically I use other methods to monitor these events.

But in reply to Amits question,...

Lee,

in SSMS if you select the "generate scripts" task on the third page in the wizard (after selecting the database) you can set all kind of options. In your case...

Hans,

the problem you have occurs if one of the index columns is a computed column. check this article:

http://support.microsoft.com/kb/301292

Markus

Basically the problem is that the parser thinks that both "select into" commands are executed.

The easiest way to solve this is defining the temp table at the beginning and then do a...

Rob,

unless the large value type column is consistently returned in the queries I usually recommend to use sp_tableoption  ‘large value types out of row’. The reason simply is that queries...

Tim,

the reason why the script fails on a 2000 server is that the options IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON,

SQL Oracle is right and I was a not clear enough.

You can deny reads or writes to memebrs of the db_owner role, but you can't do it for the...

Phani,

the effective permissions would be reading on all tables and views will be denied. There's one exception, that is if the user is also a member of the db_owner group...

Pablo,

SQL 2005 maintenance plans make use of SSIS. SSIS is not installed as a cluster resource. You need to maually install it on both nodes in order to se it....

Alan,

on the page there they tell you what you will learn, there is a link at the bottom of the page under "Next Task In Lesson". This will start the...

Alan,

in BOL search for tutorials. There it explains step for step what to do.

Markus

hi Ian,

I can't say I now anything about ACS, but if they refer to reindexing, that's usually not a task you would do on a daily basis. In fact for...

Yes, installing RS on Vista is quite a challenge and if you're using Vista Home (basic or premium) it is even wortse since Windows Authentification won't work.

In this blog you...