Joe Clifford (1/8/2008)

---

With a large database (>100GB) you probably need more than one filegroup but need to think through what you're trying to accomplish when creating your filegroups. There...

I agree with Clive, plan to migrate all the databases and keep a current backup of them. However, if you think a database is not being used you can rename...

If you want to size you data files the same across 3 drives for optimal I/O. You can create a new database with the same name as your old db...

The post by eyechart in the middle of this forum works like a charm but it involves modifying system tables and stopping and restarting SQL Server so do this on...

The migration assistant is a handy tool:

http://www.microsoft.com/sql/solutions/migration/access/default.mspx

Jeff you are a genius! Don't know why scripting from QA didn't cross my mind :crazy:

I tried many different ways to script a table but missed QA. It works like...

Thanks Jeff. In a post above I stated you can create scripts from EM. However, it generates scripts with alter statements for the PK and the constraints. The constraints must...

I need to create new tables for updatable partitioned views and would rather do a find and replace 2007 with 2008 than have to re-write all the create table statements.

What I am looking for is to generate a script from an existing table. You can script a table by right clicking on the table in EM, All Tasks, Generate...

ranjithputhan (11/19/2007)

---

Server configuration : 6Gb ram, Windows 2000 Advanced Server,SP4 Build 2195, SQL Server 2000 Enterprise Edition (sp4).

In boot.ini is set

[boot loader]

timeout=30

default=multi(0)disk(0)rdisk(0)partition(1)\WINNT

[operating systems]

multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft Windows 2000 Advanced Server" /fastdetect /3GB...

I have seen this problem before when the msdb is out of space. If you add free space to the msdb it may solve your problem.

I would also suggest splitting out things like "Name" into FName MInitial and LName. Also, "Address" into AddressLine1, AddressLine2, City, State, ZIP, County, Country. Although you may not want to...

I would suggest getting some disk space for backups and use a tool like Litespeed or SQL Backup. I use Litespeed to backup a 1.5TB db to disk in 3...

Here is an MS article with the manual uninstall instructions:

http://support.microsoft.com/kb/909967

You should be able to detach subscriber databases. It's the publisher and distributor which cannot be detached.