Viewing 15 posts - 1,276 through 1,290 (of 1,654 total)
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....
[font="Verdana"]Markus Bohse[/font]
May 31, 2007 at 1:34 am
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,...
[font="Verdana"]Markus Bohse[/font]
May 31, 2007 at 1:10 am
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...
[font="Verdana"]Markus Bohse[/font]
May 30, 2007 at 12:43 pm
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
[font="Verdana"]Markus Bohse[/font]
May 30, 2007 at 4:16 am
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...
[font="Verdana"]Markus Bohse[/font]
May 29, 2007 at 6:45 am
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...
[font="Verdana"]Markus Bohse[/font]
May 11, 2007 at 12:50 am
Tim,
the reason why the script fails on a 2000 server is that the options IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, [font="Verdana"]Markus Bohse[/font]
May 11, 2007 at 12:46 am
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...
[font="Verdana"]Markus Bohse[/font]
May 10, 2007 at 12:57 am
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...
[font="Verdana"]Markus Bohse[/font]
May 9, 2007 at 12:13 pm
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....
[font="Verdana"]Markus Bohse[/font]
May 9, 2007 at 12:10 pm
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...
[font="Verdana"]Markus Bohse[/font]
May 9, 2007 at 12:43 am
Alan,
in BOL search for tutorials. There it explains step for step what to do.
Markus
[font="Verdana"]Markus Bohse[/font]
May 8, 2007 at 12:25 pm
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...
[font="Verdana"]Markus Bohse[/font]
May 8, 2007 at 12:23 pm
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...
[font="Verdana"]Markus Bohse[/font]
May 8, 2007 at 3:23 am
No SP2 doesn't change any of this, mainly because from MS point of view it is not a problem. And from a security point of view I have to agree...
[font="Verdana"]Markus Bohse[/font]
May 7, 2007 at 8:25 am
Viewing 15 posts - 1,276 through 1,290 (of 1,654 total)