Viewing 15 posts - 38,161 through 38,175 (of 39,901 total)
Personally, I'd let the instances compete and then see what happens. SQL does a good job of managing itself, though I'm not sure how the instances will work with each...
March 21, 2002 at 1:19 pm
I think you are doing this backwards. Any changes that you make to your production server should have already been made on your test database. That is the purpose of...
March 21, 2002 at 1:14 pm
I believe a detach / attach will work. You can also backup and restore from these two if I remember. Raul Sharma and Brian Knight have articles on this subject...
March 21, 2002 at 9:34 am
It sounds like you have an installation issue. I saw a similar post recently, search "dbase" and you should find it. Once this is up, it usually works, though I...
March 21, 2002 at 9:31 am
I use the backup restore method to move the backups. This is nice because if I need to to the development db twice in one day, I am not going...
March 21, 2002 at 9:29 am
March 21, 2002 at 9:27 am
I did this in v6.5, but used 2 tables. One for tables and one for columns to make notes. Basically objectname and comment fields.
Steve Jones
March 21, 2002 at 9:20 am
Here's a ref:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_m_l_9jfo.asp
I also used VB 6, W2K Pro, SQL 2K personal, to get a list of servers with this function:
Public Function ListAllServers(i As Integer)
Dim ServerList As NameList
Dim objDMO As...
March 20, 2002 at 5:37 pm
you are welcome. this is a handy feature, but I'm not thrilled with it's implementation in 2000. Can't get all the comments at once.
Steve Jones
March 20, 2002 at 3:33 pm
Not in SQL 7, but in SQL 2000, in design mode, there is a place to enter a comment.
Steve Jones
March 20, 2002 at 3:02 pm
Sounds like a problem with the package. Two things:
1. can you run this package from another machine?
2. Rebuild the package and see if that fixes it.
Steve Jones
March 20, 2002 at 9:46 am
Antares is correct. There is no way to know when activity occurs. You would also have to define activity. Is this an Insert/Update/Delete or a Select? Harder to track selects.
Steve...
March 19, 2002 at 4:10 pm
Haven't used the SQL transcenders, but the W2K ones are pretty good. I'd expect the sql ones are as well.
Used MeasureUp for SQL 7. Wasn't thrilled with them.
Steve Jones
March 19, 2002 at 12:09 pm
You can look at the FMStocks application at MS. It uses a middle tier with rights that the end user does not have.
Steve Jones
March 19, 2002 at 10:09 am
Primarily MS here, (VB or ASP with ADO). Cold Fusion which uses ODBC or OLEDB to connect.
Steve Jones
March 19, 2002 at 9:47 am
Viewing 15 posts - 38,161 through 38,175 (of 39,901 total)