| Groups | Blog | Home |
|
March 2003 April 2003 May 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 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 |
Filter by week: 1 2 3 4 5 Trouble moving db to another sql2005 Posted by dgk at 12/21/2006 10:44:34 AM I'm trying to copy a database from my machine's SQLServer2005 to a
production machine. I tried a restore from backup, which gave me an
error that the on disk structure was 611 and the production machine
supports 539. I've looked around and found similar problems, but those
were all involving SQL...more >>
Moving SQLExpress database to SQLServer? Posted by dgk at 12/20/2006 11:50:55 AM I've been developing an ASP.NET app using the default user and profile
provider, which is SQLExpress. But to go live we are going to use
SQLServer2005. I know I can use the ASPNET_REQSQL tool to prime
SQL2005, which apparently just creates an ASPNETDB.MDF file. However,
since I already have a lo...more >>
Where is AdventureWorks in 2005? Posted by brett at 12/19/2006 11:53:46 AM I've installed the Developer edition of SQL Server 2005. The sample
databases were selected. When I loaded management studio, I don't see
the AdventureWorks database. I did a search on the hard drive and
nothing came up except something related to reporting in a templates
folder. No MDF file...more >>
Starting SQL Server 2005 Manually Posted by rn5a NO[at]SPAM rediffmail.com at 12/18/2006 6:51:12 PM I am working on WinXP Pro & use SQL Server 2005 as the database server.
Whenever I log into WinXP, I find that it takes considerable time to
start (though the desktop appears in a jiffy). When I had a look at the
processes running in my m/c by opening Task Manager & clicking the
Processes tab, I...more >>
script xp_cmdshell Posted by tolcis at 12/18/2006 7:45:24 AM Hi!
I have a batch file (.bat) that I need to execute inside my stored
procedure (SQL 2000).
I am trying to call that batch file using xp_cmdshell command. I am
probably not using it the right way but I am trying to pass a path of
the batch file into xp_cmdshell and it doesn't recognizes it ...more >>
SQLserverTool Posted by jjrmy1 at 12/15/2006 4:54:05 PM Anyone have any suggestions for a good, user friendly, db management tool
for SQL server?
Needs to be able to create tables, insert records, modify columns, etc.
Thanks,
Jeremy
...more >>
Cold backups Posted by stavros at 12/15/2006 2:03:40 PM I'm going to shut down the SQLServer services (SQL 2000) and do a cold
backup of all the databases before performing some system upgrades.
BOL doesn't have much information on cold backups. Is it an absolute
requirement to back up both the data and log files in a cold backup, or
are the data fi...more >>
OPENROWSET and network share Posted by Gugale at Lincoln at 12/15/2006 12:00:00 AM Hi,
I am not able to execute following command from computers other than the SQL
server itself.
select * from openrowset(bulk N'\\ImageServer\Model\Cam_05.dwg',
SINGLE_BLOB) as doc
I get following error message:
Msg 4861, Level 16, State 1, Line 1
Cannot bulk load because th...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |