Viewing 15 posts - 4,096 through 4,110 (of 7,502 total)
So, what do you do without standards ?
Some won't do business with you if you're not certified ISO...
Which one to pick is up to the company.
IMO things like SOx or...
January 26, 2009 at 12:18 am
how long are they up and running after SP3 ?
Keep in mind SP3 stops and starts sqlserver a number of times, so buffer cache will be cleared !
(our clustered instances...
January 26, 2009 at 12:06 am
- your sqlagent has not been started (cluster manager)
(do you use SQLAgent ?)
- you can enable these procs this way:
-- enable Agent XPs
EXEC sp_configure 'Agent XPs','1'
RECONFIGURE
GO
This way you can...
January 25, 2009 at 11:51 pm
cluttering is another branche 😉
Steve showed you some good refs for SQLServer clustering.
Another good ref is the SQL Server 2005 Failover Clustering White Paper http://www.microsoft.com/downloads/details.aspx?familyid=818234dc-a17b-4f09-b282-c6830fead499&displaylang=en
It always pays of to have...
January 25, 2009 at 10:39 am
Mad-Dog (1/25/2009)
has anyone that have sp3 install and setup this alert in the SQL alert doesn't suffer from...
January 25, 2009 at 10:34 am
Jeff Moden (1/25/2009)
Thanks for the links, Johan... I'll take a look (am I spelling your name correctly?)
Yep, Johan is correct.:w00t:
January 25, 2009 at 9:30 am
I first installed it on a couple of non clustered instances.
I don't perform unattended installs .... must be my age 😉
Basic scenario on our cluster:
- move over all instances to...
January 25, 2009 at 4:22 am
Jeff Moden (1/24/2009)
... if they fit, that's as far as they go. If they don't, then they spill into the physical disk.
"If" is the unknown over here,...
January 25, 2009 at 3:45 am
It was a x64 cluster (2 nodes / 5 instances) all updated in a single run (because of the approved downtime). The actual upgrade took about a bit less than...
January 25, 2009 at 3:36 am
since you're at it ... this is what I experienced with logon triggers : http://www.sqlservercentral.com/articles/Administration/64974/
With regards to the login info:
Select name
, create_date
...
January 24, 2009 at 9:01 am
also keep in mind temp tables (@ / # / ## ) are hosted in tempdb. tempdb is used at (sqlserver) instance level, for more than only storing temp tables....
January 24, 2009 at 8:57 am
I didn't encounter any issues applying SP3. (x86 / x64)
The 5 servers were we were on SP2 CU10 I have also upgraded to SP3 + CU1 without an issue.
January 24, 2009 at 7:18 am
TheSQLGuru (1/22/2009)
Joe Celko (1/22/2009)
January 23, 2009 at 12:05 am
Norm (1/22/2009)
....question: Would xp_cmdshell still have to be enabled if I run it as a operating system (cmdexec) type in my sql server job?
No, you can disable xp_cmdshell, SQLAgent has...
January 22, 2009 at 12:45 pm
- Did your stop trace work ?
- Since you are using "EXEC xp_cmdshell 'd:\mssql\scripts\audit\rename_ddltrace.bat', NO_OUTPUT"
Why don't you just provide the rename statement itself ?
Dim @Doscmd nvarchar(max)
Set @Doscmd = 'ren D:\MSSQL\reports\audit\audit_ddl.trc...
January 22, 2009 at 7:35 am
Viewing 15 posts - 4,096 through 4,110 (of 7,502 total)