| Groups | Blog | Home |
|
November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 I can't believe that microsoft would make something that should be easy so obscure and difficult Posted by keithb at 3/31/2006 8:30:18 AM db backups made using Sqlserver 2k Enterprise Mananger do not have a file
extension. The restore program in Sqlserver 2k5 is looking for files with a
..bak extension. Can someone please explain step-by step how to
1) make a db backup in sqlserver 2k that can be restored un 2k5
2) how to use sq...more >>
Problem with table owners Posted by david epsom dot com dot au at 3/31/2006 12:00:00 AM I am a naive user.
We have a database where some of the tables are duplicated.
One version of the table is owned by dbo, the other is owned by "test_admin"
How do you get a table owned by "test_admin".
When would you deliberately choose to have a table not owned by dbo?
Is it ever safe ...more >>
SQL Server2005 Developer Edition Posted by JL at 3/30/2006 6:23:54 PM I have an HP Pavilion laptop running Windows XP Home Edition with
SP2.Can I run SQL Sever2005 Developer Edition on this machine or do I
need XP Professional?
I also want to run Report Services and see that it requires IIS to be
installed. Does IIS come with the Developer Edition or do I have t...more >>
How to restore a sqlserver2000 db backup to sqlserver2005? Posted by keithb at 3/30/2006 9:05:14 AM How to restore a sqlserver2000 db backup to sqlserver2005?
Thanks,
Keith
...more >>
How can be create a updatable view whit DISTINCT clause? Posted by Dan Enache at 3/30/2006 12:00:00 AM How can be create a updatable view whit DISTINCT clause?
TIA
Dan
...more >>
sql 2000 to sql 2005 Posted by John at 3/29/2006 5:06:10 PM Hi
How can I move a sql 2005 db (data and all) to sql server 2000? I have made
the mistake of developing on sql server 2005 and now found out that
production server is still 2000.
Thanks
Regards
...more >>
Problem migrating by restoring SQLServer2k backup to 2k5 database Posted by keithb at 3/29/2006 10:08:05 AM Please help. I'm trying to migrate a 2k database to 2k5, and must be doing
something wrong. Using the SQL Server Management Studio Express CTP database
Restore function, I was unable to navigate to the SQLServer2K backup file
location, so I copied the 2k backup into the SQLServer 2K5 backup fo...more >>
SQL Server Express - is there something like Enterprise Manager for SQL Server Express? Posted by keithb at 3/29/2006 9:35:39 AM According to Programs | Micrsoft SQL Server 2005 | Configuration Tools | SQL
Server Configuration Manager, I have instances of SQL Server (SQLEXPRESS),
and SQL Server Browser running. I see no other evidence of these programs,
and there doesn't seem to be a menu item similar to Enterprise Mana...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How can I 'Port' a SQL:Server 2000 database to SQLServer 2005? Posted by keithb at 3/29/2006 8:45:12 AM How can I 'Port' a SQL:Server 2000 database to SQLServer 2005?
Thanks,
Keith
...more >>
Merging two dbs Posted by John at 3/29/2006 1:34:50 AM Hi
I have two sql server 2005 dbs on server A. I need to copy all items
(tables, view, sps and so on) from the two dbs into a single db on server B.
The added problem is that server B is SQL Server 2000 so direct copy is
perhaps not possible. How can I achieve this?
Thanks
Regards
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |