Viewing 15 posts - 39,586 through 39,600 (of 39,754 total)
Can you try in under the local administrator account? I am concerned that permissions or security were altered somewhere else. Itis possible there is some corruption somewhere in a file...
September 20, 2001 at 9:42 am
We also have a special now on the test preps for both 2K and 7. I think either cert is beneficial. There are lots of v7 sites out there, that...
September 20, 2001 at 9:35 am
I believe the NT WK and Win2K Pro have a 10 user connection limit. There may be 2 system type processes eating up the other two conenctions.
Steve Jones
September 19, 2001 at 3:55 pm
September 19, 2001 at 3:51 pm
September 19, 2001 at 3:50 pm
I'm not sure. Since I know a little, I'd write out the data using DataPump. Then I'd use an ActiveX task to write a new file with the info and...
September 19, 2001 at 3:50 pm
I know you can change package variables, but I'd have to dig through to figure this one out.
I have an ActiveX script that worked in v7.0, that changed the connection...
September 19, 2001 at 3:48 pm
How are SQL Server Agent and MSSQl Server configure in the services? Which account?
Can you log in as the account under which SSA is running?
Steve Jones
September 19, 2001 at 11:18 am
September 18, 2001 at 7:22 pm
you cannot disable logging. even "on chkpt" logs the operation. You don't want to disable this. it is your safety net.
better to spend some $$ on another disk for logs.
Steve...
September 18, 2001 at 7:21 pm
September 18, 2001 at 7:18 pm
I thought 70-229 was straightforward and fair.
I agree with Andy about employers. Most don't care, but you can call attention to yourself with the certs.
Steve Jones
September 18, 2001 at 7:17 pm
As far as I know, with v7 and later, triggers are not supported on system tables.
Steve Jones
September 17, 2001 at 1:50 pm
September 17, 2001 at 1:49 pm
Here's what I have in an include file for my ASP pages:
Dim objConn, rsTable, strConnMatrix
Set objConn = Server.CreateObject("ADODB.Connection")
Set rsTable = Server.CreateObject("ADODB.RecordSet")
strConnMatrixDBA = "provider=SQLOLEDB;Data Source=Matrix;User Id=dba;password=xxxxxx;Initial Catalog=dba"
I have a strConnxxx...
September 17, 2001 at 1:48 pm
Viewing 15 posts - 39,586 through 39,600 (of 39,754 total)