Hi,
Is there a way to backup a particular database (MS SQL7.0) by writing a script to do(automated) it? The user must not login using system admin password.
Thanks
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10303343.html
I have added alot of new records and need to reindex 10 of the indexes in one table in SQL7. Is this what would be best?
DBCC DBREINDEX
('database.owner.table_name')
All assistance is g...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20438165.html
Hi there,
I was wondering if anyone can help at all?
I am trying to create a subscription to a Publication that I know exists. The problem is that when I view the available servers (using the...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20449470.html
Hi Experts,
Here is what I'm trying to do:
I have a SQL7 database on the desktop. I already have a website that accessing to this database. I also have a form for PocketPC. On this form, I n...
http://www.experts-exchange.com/Programming/Handhelds_-_PDAs/Pocket_PCs_All/Q_21660524.htm...
Aloha,
I have a database that worked originally in ACCESS 2000. I've since created a SQL database with SQL7 Enterprise manager. The ACCESS database has been imported and relationships re-estab...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_11593018.html
Greetings Experts,
I've seen variations of this topic/question but I am hoping to get a more refined/specific answer or set of steps.
I have an SQL7 database on a wheezing server that I woul...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21259362.html
Hi,
I'm using VB6, ADO and SQL7. I have created a Stored Procedure (SP)with one input parameter variable (varchar) , and the SP returns a recordset. I'm using the command object and the parameter...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_DB/Q_10169553.html
Zones:
VB DBDate Answered: 06/09/1999 Grade: A Views: 0
I have just ran my VB application which uses ADO.
I now look in the locking information in SQL7 and see that I have a locktype of DB.
Am I really locking the database ??
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20170024.html
I detached a DB from SQL 7 server SP4(and also keep a backup of the DB), and then I uninstalled the sql server. Bow, I am trying to attach (and also tried to restore) the DB into another server wit...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20457175.html
Hi there
Im playing around with SQL7 as im going to be rebuilding the server and upgrading to SQL2000. Its all new to me so I have a 'how to' question.
I will do a full backup and restore of...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21547174.html
