|
|
|
January 2003 March 2003 April 2003 May 2003 June 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 November 2007 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 SQL Backup using SMO: Timeout 600s Posted by Håkan at 5/6/2006 10:39:19 PM Hi!
I am trying to backup all databases from a SQL 2005 Express server. One of
the databases is rather large and while backing up it I receive a time out
after 600 s (10 minutes).
I can't find any where to set the time out for the backup command.
So, How do I set the timeout that SMO use...more >>
osql Posted by Derek Hart at 5/6/2006 9:04:48 PM Is there a way to detect errors if I use osql to execute sql statements?
Derek Hart
...more >>
sql server scptxfr.exe go Posted by Derek Hart at 5/6/2006 8:39:05 PM I am using scptxfr.exe to script out a SQL Server 2000 database. I want to
run the script inside a VB.NET application, but the scptxfr.exe adds the
keyword GO after every command, which I believe is not a transact-sql
statement, so it errors. I did not see a command line option to turn this ...more >>
Return End Time from Start Time and Duration Posted by richardb at 5/6/2006 7:57:01 PM I am trying to SELECT and return the end time from a Scheduler database. The
information available is
Start Time, for example: 01/01/1900 8:00:00 AM
Duration, for example: 01/01/1900 1:00:00 AM
In this example, I would want the returned column to read 9:00 AM (or 8:59
AM) for a one hour a...more >>
2K and 2K5 on Same Dev Box Posted by Jeremy S. at 5/6/2006 7:20:54 PM Can SQL Server 2000 and 2005 coexist on the same development computer? Or do
I really need to have one or the other.
Thanks!
...more >>
SQLXML 2000 Question Posted by thejamie at 5/6/2006 3:40:02 PM I hope this question has a simple answer. I am cramming for the 70-228 exam
and I am running throught the chapter on ETL. The beginning asks me to add
an SQLXML virtual server and apparently I should be able to access the
database via the Internet Explorer with this query.
http://localhos...more >>
ASP script to display database structure? Posted by Noozer at 5/6/2006 11:37:58 AM Posted this to SQLServer.Tools, but maybe it belongs here...
Does anyone have an ASP script that I can use to dump the structure of an MS
SQL 2000 database?
The firewall here won't allow any remote connections through, and our DB
host does not have any web administration.
I just need ...more >>
How to free up SQL 2000 transaction log space? Posted by Mark Findlay at 5/6/2006 10:39:22 AM I have tried all of the Shrink database options provided by Enterprise
Manager to try and shrink my transaction log from its current size of 2Gig,
but no matter what I execute it stays 2Gig.
I selected the option to reduce to its minimum allowable size (which it
showed as about 300Meg), but...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Credit Card Validation Posted by Shiva at 5/6/2006 10:20:52 AM Hi,
I have a bunch of bad credit cards in my database and need a SQL Script to
find out which ones are actually bad. Does any of you have a credit card
validation sql script that I maybe able to use?
Thank you,
Shiva
...more >>
Connect to Server -- login error message 233 :sql server express edition Posted by Jon Paal at 5/6/2006 8:21:26 AM TITLE: Cannot login to Server with SQL Server Authentication from Sql Server Manager Express Edition
------------------------------
ADDITIONAL INFORMATION:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared
Memor...more >>
Dynamic SQL statement Posted by Stephen K. Miyasato at 5/6/2006 6:36:09 AM I'm still a newbie and can't get this dynamic SQL statement to work. Any
help appreciated.
Declare @sqlStmt nvarchar(500)
Declare @PatNo int
Declare @Range int
set @PatNO = 240
Set @Range = 36000
--EXEC --('insert Into ' + @TempVS +
SET @sqlStmt = 'Select Distinct patNo, DateDrawn, Sort,T...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |