|
|
|
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 Rename a database Posted by et at 5/6/2006 11:06:33 AM How do I rename a database on sql server 2000? I have a database I brought
up from a backup and has the same name as the current database. I don't
want to detach the current one because I have to get data from both
databases. I tried renaming the file name of the backup copy, and in the
a...more >>
Cannot open database "mydb" requested by the login. Posted by cas at 5/5/2006 9:30:38 PM Hi,
I installed sqlserver 2005 express on windows server 2000 sp4.
I made a new database ("mydb") with sql server Management studio express
(not a mdf file).
I also defined tables and i can make and execute queries in sql server
Management studio express without problem.
I granted to accou...more >>
Keeping a query Posted by Fembo at 5/5/2006 6:12:54 PM Hello,
Using query analyzer is it possible to rem out a query so it can be used
again?
Any assistance would be appreciated.
Femi
...more >>
sqlServerExpress Posted by Bob Palank at 5/5/2006 4:46:00 PM Is it possible to post an mdf database file into a folder on some webserver
and then develop a VB.Net application that would access that database ? The
folder on the server would know nothing about an SQL Server. It simply holds
a mdf file.
BR
Bob
...more >>
SQL Server 2005 DTS import tool Posted by R Weeden at 5/5/2006 8:22:15 AM In SQL2000 there is a tool to import CSV files. Where is the import tool in
SQL2005?
Bob W
...more >>
sql2005 database mirroring Posted by adam at 5/5/2006 12:00:00 AM hi,
i'm new to this group.
i wonder if i can get answers to my question here, cos i cant find a
newsgroup with database mirroring.
i have two servers :
pSQL - principal
mSQL - mirror
Have successfully create the endpoints at both servers.
Have checked on the port 5021 listening at both...more >>
add addlogin with passthrough query Posted by Sam at 5/5/2006 12:00:00 AM how can i able a user to add new login from whithin the application .
when user runs a passthrough query with the sp_addlogin command
there is a message that user does not have permission to this action
thanks
...more >>
Using a formula in a table field Posted by Conan Kelly at 5/4/2006 10:47:45 AM Hello all,
Using SQL Server 2000 (Standard Edition, I think).
I was trying to educate myself on creating functions and in one of the examples in Books Online I noticed that you could use
formulas in fields in a table, calculating the field value using other fields as arguments.
My questio...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Creating a Test Server From a Live Server - Auto Refresh Posted by MBSNewbie at 5/3/2006 11:16:32 AM Hi All,
I'm hoping someone may be able to help me out.
We are running multiple databases on our SQL Server. I would like to create
a test environment based on the existing databases. (Because I'm new, I
don't want to mess up what is there) I have been trying for a week to copy,
backup & rest...more >>
Problems migrating from 2000 to 2005 Posted by Paul at 5/2/2006 1:03:37 PM I downloaded the trial version of SQL Server 2005 to facilitate the
migration of a web site database from a SQL2000 server to the new host's
2005 SQL Server.
It transferred the data itself OK, but I found two major problems with the
structure:
1. All my Views were created as Tables inste...more >>
SQL vs Access Newbie Question Posted by Thomas Grassi at 5/1/2006 9:45:52 PM I have a SQL 2000 Server database on my windows xp pro pc. I would like to
have my Access Data base Office XP PRo SP3 Link to the SQL database so I can
run queries and reports in Access. How do I do that? Any exmples would be
helpful
Thanks
Tom
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |