Viewing 15 posts - 39,301 through 39,315 (of 39,466 total)
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
My 2 cents:
Avoid Access.
It is intended as a low end, personal desktop database. While I have built lots of dBase/FoxPro/Access applications, they don't scale well and coruption is a...
September 15, 2001 at 10:34 am
I wouldn't call this ludicrous either. I, in general, hate cursors and temp tables, but they have value. While I wouldn't use this approach, it appears to work.
Personally, I'd burden...
September 15, 2001 at 10:20 am
I know it costs $$, but you can run SQL 2000 with a db in 6.5 compatability. Might provide some reasons to upgrade. The query performance will only increase.
Steve Jones
September 14, 2001 at 4:18 pm
Viewing 15 posts - 39,301 through 39,315 (of 39,466 total)