Viewing 15 posts - 39,556 through 39,570 (of 39,717 total)
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
September 13, 2001 at 9:26 am
I'd be wary to removing any "system" like tables. HAve you noticed any issues? Do they get recreated with a new diagram?
Steve Jones
September 13, 2001 at 9:24 am
I had, but I use the same job on multiple servers and use the Dynamic Variable Settings to get some information for the package. This way I can also do...
September 13, 2001 at 9:22 am
September 13, 2001 at 9:17 am
Viewing 15 posts - 39,556 through 39,570 (of 39,717 total)