SQL Server7
Aug 5, 2000
hi,
i'm new to this sql server thing. i hope somebody can help me out!
i would like to find a way to determine whether or not the automated
backup of the database has been done without using the sql mail
functionality. i'm not allowed to use that because it only runs for
the microsoft outlook and it cost too much space. the server is in one
of our clients and they do not have a db admin, and nobody wants to go
there can i do something????
View 1 Replies
Feb 9, 2001
Does anyone know the advantages of using a view over a store procedure? Are there any proformance differences?
thanks
steve
View 2 Replies
View Related
Aug 19, 1999
I just brought SQL Server 7.0. Previously i am using Access97 . I am building some Asp stuffs using Access
Database. NOw i move the database Access to Sql server. I am planning to install this sql in separate machine
in the network.
After the installation, i need to use the database for my Asp programs..
I would like to know what are the things that i should keep(follow) while installing SQL Server 7.0.
Also i need to know some Admin procedure..Where i can found..?
Help will be appreciated.
Thanks
rams
View 1 Replies
View Related
Jan 13, 2000
I'm worhing with SQL Server7.0 and I have created a database.
I have objets and data in my database
My database have 300Mb and I only need about 50.
How can I reduce to 50 the dimension of my database.
Is it posible??
Any advice will be greatly apreciatted.
Nauj
View 2 Replies
View Related
Jul 27, 1999
Can SQL server7 restore a single table? If one table corrupted, do I have to restore the whole database for this table ?( It is awkward to restore the whole database only for a single table! especially the database is large!)
thanks,
View 3 Replies
View Related
Aug 1, 2004
I have a full backup done on a very important server 7 database. Now i have to test to see if it is saving okay and to do a mock restore to see how quickly we can restore same. The size of the file is about 700M. I would have to do my testing on a test server. How do I go about this.
Thanks.
View 2 Replies
View Related
Aug 14, 2004
Hello,
Can anyone please tell me the best way to upgrade server1 with SERVER7 and OS of NT to a new server2 with SERVER2000 AND WINDOWS 2000 ?
The data in the old server is very important.
Thanks
View 2 Replies
View Related
Jul 20, 2005
HelloDoes anyone one know the max size of a database that I can create onMS-SQL server 7. Have had any problems using databases near the maxsize (slow performance, etc)ThanksHelena
View 2 Replies
View Related
Jul 9, 2001
Hi
we are having SQL server7.0 with DPT raid card which gives the problem of backup/restore through normal SQL backup in Enterprise manager.So we are not using the above procedure
but we have moved all the tables using SQL EXPORT to another new server.
Can you please give a solution to transfer Stored procedure from the server to new server
Regards
Rajakumar
View 1 Replies
View Related
Jun 18, 1999
Hi,
The company finally bought a legitimate copy of SQL Server 7. There was nothing special on my trial version, so I chose the uninstall option from the start menu (it was on my Win95 PC). It removed the files, but didn't uninstall the registry bits though! When trying to install the proper version of SQL 7 it has detected the other version, but no files & won't let me install the legitimate version. Can anyone tell me how to get around this to install the new version?
Thanks
Steve
View 1 Replies
View Related
Aug 5, 2004
I posted this problem last week and still couldn't get this to work.
I have a backed up copy of a production db that i want to test. The production server is using server 7 white i have 2000 at my desktop. How can i get this to work ? I am beginning to 'lose' it.
Any help would be greatly appreciated. I would like to complete this test today.
Thanks
View 5 Replies
View Related
Jan 22, 2001
Hello,
When I try to create a primary key for a table(alter table tablename add primary key( columnname)), I get a message
" SQL 1918. ( Index (key=2) is being rebuilt)."
Does any one have a clue, as to why do I get this. The primary key does get created ,but my application stops working, after getting this message.
Thanks,
Mitesh
View 1 Replies
View Related
Aug 11, 2004
Hello,
I have to do an upgrade from server 7 and OS NT to server2000 and windows 2000. Has anyone had any problems while doing this ? Please list the steps taken for the upgrade if you can.
Thanks
View 1 Replies
View Related
Jun 10, 2001
I am a beginner in learning SQLServer 7.And I learn it by using its own help file.
The only problem troubles me is that after I do some options in database diagram,there's nothing happen.And then no matter what I do,database diagram panel is always blank.
View 2 Replies
View Related
