Viewing 15 posts - 39,781 through 39,795 (of 39,936 total)
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
Try saving the package with a password. This alleviates many problems.
Be sure you have not used any SQL 2K specific tasks. A number of new tasks are only supported on...
September 13, 2001 at 9:15 am
I am working on an article, but here is my ActiveX script that I use:
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=74
Steve Jones
September 12, 2001 at 10:45 am
September 12, 2001 at 10:36 am
Haven't worked with multiple instances. I'd test on the 2nd instance and move to the first for production. The naming is more complex for 2nd instances, so if it works...
September 12, 2001 at 10:34 am
Try this:http://www.sqlservercentral.com/columnists/rsharma/copydatabase.asp
Steve Jones
September 12, 2001 at 10:30 am
The v7 Design test was harder than the v2000 test, IMHO. I took both within a few weeks of each other. Of course, I work in 2000 most of the...
September 12, 2001 at 10:25 am
Viewing 15 posts - 39,781 through 39,795 (of 39,936 total)