Viewing 15 posts - 2,746 through 2,760 (of 2,903 total)
Once you unpack the Service Pack, find the HTML file sp3readme. Open that file and go to section 3.10.
-SQLBill
April 23, 2003 at 5:32 am
One way to find the creation date is to right click on MY Computer, select Explore. Drill down to where you installed MS SQL Server. Right click on the directory...
April 22, 2003 at 6:45 am
A normal backup will NOT have the extension .MDF or .LDF! To have backups that use those extensions, you have to detach the database and COPY the .MDF and .LDF...
April 21, 2003 at 10:59 am
You need to set a strong password for the SA account!!!! That's why SP 3 requires it. If you do not give SA a password you are VERY vulnerable to...
April 21, 2003 at 6:47 am
You are asking about two different things.
1. The query. And the solution given should work.
2. The connection. The way you connect to the database has very little to do with...
April 21, 2003 at 6:42 am
April 18, 2003 at 12:39 pm
I seem to recall that Microsoft's information says that the MSDE database has a maximum size of 2GB.
-SQLBill
April 18, 2003 at 12:35 pm
It's never a bad idea to copy the .mdf and .ldf during down times. It gives you the best way to restore data. Just remember:
If you restore using the .mdf/.ldf...
April 17, 2003 at 5:59 am
Have you created a dump device (sp_addumpdevice)? That's the first step.
Next, go to Enterprise Manager, expand your server, expand Management, expand SQL Server Agent, right click on JOBS and select...
April 17, 2003 at 5:52 am
You can recover a database by using the .mdf and .ldf files. This is actually the easiest way to RECOVER a database since you only need to do an attach...
April 16, 2003 at 11:55 am
It appears to me that you first upgrade/install SQL Server 2000 SP 3 and THEN upgrade to Windows 2003.
-SQLBill
April 16, 2003 at 11:35 am
This is the only thing I was able to find:
http://www.microsoft.com/sql/howtobuy/windowsnetsupport.asp
-SQLBill
April 16, 2003 at 11:33 am
April 16, 2003 at 11:20 am
Can you provide more information? How are the tables linked; what are they linked on? What is the structure of each table?
-SQLBill
April 16, 2003 at 5:46 am
I'm hoping this isn't a double posting...but I got an error page with my first try....
Steve,
I would also want to know how long it takes them to upgrade their product...
April 14, 2003 at 11:13 am
Viewing 15 posts - 2,746 through 2,760 (of 2,903 total)