We typically revoke the sysadmin role from this account on our instances but I'm running into a problem doing this when I have a Cluster.It appears that the cluster services require this role.Has anyone determined a way around this?thks
2004-10-05
1 reads
Please anyone correct me if I am wrong.I assume that you are using HypherThread since you are talking about logical CPU. Then, first, I'd like to know what is the O/S that you are using. This is from MSFT white paper about O/S. 2-way 4-way8-wayWindows Server ProductPhysicalLogicalPhysicalLogicalPhysicalLogicalWindows 2000 Server2444n/an/aWindows 2000 Advanced Server 244888Windows 2000 Datacenter […]
2004-09-27
SQL handles mapped drives very difficultly. You won't be able to see the mapped drive unless the same login was used to create it. The only way I've been able to used mapped drives is to perform the mapping from within QA via xp_cmdshell 'net use m:...' There are other ways around it but this […]
2004-09-22
Well ... thanks! I don't usually lose my patience with people, and I feel stupid for tooting my own horn, but I was a little frustrated with Sukhoi. Thanks for helping me calm down! By the way, the following Oracle snippet ...SELECT ... FROM ...,INTERMEDIARY,CODE_VALUE A,CODE_VALUE B,... Where ... AND INTERMEDIARY.INTERMEDIARY_TYPE(+)=A.CODE_VALUE_ID AND INTERMEDIARY.OWNERSHIP(+)=B.CODE_VALUE_ID […]
2004-09-14
Exactly. The question should read "over 2 billion objects". The thing the documentation doesn't indicate is whether or not that includes the system objects. I guess when you are talking about billions, a couple hundred don't matter. Just curious though.http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
2004-09-03
Have you tried the following: SELECT dbo.udf_FunctionNameHere ?? Also some require () at the end..
2004-09-02
You should verfiy if you use returnAverages in your scripts. It may be a stored procedure you forgot to script. Look for the procedure on the original server and create it also on the new server ... I did not find it on my servers, so it is not a standard procedure. When reading "the […]
2004-08-31
you could set up your oracle server as a linked server in SQL you can then create a view in your SQL server that does the join for you. ou can then just connect to the SQL server from ASP and load the recordset
2004-08-19
I tried the same thing myself. I ran into no issues. The only difference was I did not build the SQL string I created a static string.I suggest adding a MsgBox statement for debugging to determine the point the package is dying at exactly.Also add "Option Explicit" at the begining of the ActiveX script to […]
2004-08-17
You will need to edit the registry. HKEY_Local_Machine\SOFTWARE\Microsoft\MSSQLServer\ParametersChange the SQLArg0 to reflect the new path and file name of the master data file.Change the SQLArg1 to reflect the new path for your error logsChange the SQLArg2 to reflect the new path for the master log fileSQL Server should start although it probably would have been […]
2004-08-05
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Hi! Query store provides information on workloads on tempdb How\Steps to setup Extended events...
Hi, I have a table that stores event transactions, the sample data see the...
I am trying to create a natively compiled stored procedure where I need to...
Ask SSC