|
|
|
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 SQL Server 2005 Express uninstall? Posted by ksspriggs at 10/20/2006 10:02:02 AM I currently have SQL Server 2005 Express and Management Studio Express
installed. I want to switch to the 180 free trial version of SQL Server 2005
(Standard).
Do I have to uninstall both Express and Managemnt Studion Express before
installing the 180 free trail? Or do I just need to unins...more >>
Conditional statment question. Posted by Jim Moberg at 10/20/2006 8:19:02 AM I'm trying to convert an MS-Access query so that it uses T-SQL code in Query
Analyzer. I'm stuck at one point. The MS-Access query has the following
field definition and conditional statement:
NewClID: IIf(IsNull([CL_ID]),"0",[CL_ID])
How do I convert this to T-SQL. I have looked and lo...more >>
SQL Server 200 DTS Package Question Posted by Frank at 10/19/2006 3:19:27 PM I wish to create a package that I may schedule to run every x amount of
minutes.
I have successfully done this twice before where the package simply grabs
data form one db and inserts newly created rows into another db table.
Now however, I wish to
Have the package grab the source da...more >>
loging on using Vista RC1 Posted by Nigel S at 10/19/2006 7:49:01 AM Hi
I just tried to log on to SQL 2005 managment studio using windows
authentication.
It keeps giving me a logon failure with Error No 18456.
I am logged on as administrator and the greyed-out user name shows
administrator, this has only started happening since upgrading to Vista RC1.
...more >>
SQL Server Licensing costs Posted by shikarishambu at 10/18/2006 6:11:31 PM What is the annual license maintenance costs for SQL Server. Is it a %age of
the product license costs
TIA
...more >>
SQL 2000 dynamic query Posted by venkat at 10/18/2006 5:11:48 PM Hi,
I am trying to migrate some data from dev db to prod db.
I am trying to do this by creating queries in query analyzer like
SET QUOTED_IDENTIFIER OFF
select "Insert into productinfo (programname) values ('" + productname from
productinfo where product_id=21 + "')"
I am getting
Synta...more >>
Info on SQL Mail for SQL Serv2000 Posted by Rachel Barrientez at 10/18/2006 11:19:36 AM I need any info anyone can share on utilizing SQL Mail for SQL Server 2000.
We use Job Scheduler and at times we find errors on there but it is a manual
visual check up. Trying to find a way for e-mail to be sent out when
specific errors happen on Job Scheduler. Any ideas? If need more info...more >>
Can't delete backup job!!! Posted by RandyH at 10/18/2006 9:08:25 AM For the life of me, I can't delete a backup job that was created with the
maintenance wizard.
The job deletes from the Management\Maintenance tree, but doesn't delete
from the SQL Server Agent tree.
I script the job to drop and get this error msg:
Msg 547, Level 16, State 0, Procedure s...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How do I download a HotFix? Posted by Mark S. at 10/17/2006 10:08:32 PM Hello,
After finally convincing my client to upgrade to SQL Server 2005 Enterprise
Edition SP1, we run smack into three bugs that have been fixed by hot fixes:
http://support.microsoft.com/default.aspx?scid=kb;en-us;911569&sd=rss&spid=2852
http://support.microsoft.com/kb/919144
http://supp...more >>
Sort order again Posted by Esha at 10/17/2006 1:02:16 PM Some time ago I met a difference in behavior of SQL 2000 EM and SQL 2005
Management Studio.
In 2000 I always have table data displayed in order it was entered when I
use Open Table from popup menu, while I get unordered data when I use Open
Table in MS. Although I've got some answers explaini...more >>
SQL to MySQL Posted by te_butts at 10/16/2006 8:14:01 AM Is there a way to take a DB from SQL2000 and SQL2005 to MySQL?
Thanks...more >>
Going from SQL2000 and SQL2005 to MySQL Posted by te_butts at 10/16/2006 8:08:02 AM Can you take a SQL2000 and SQL2005 database and convert it to a MySQL
database? By backing up, or exporting, or something along those lines.
The powers above want to me to move all of our websites, which have both
2000 and 2005 SQL DB's, to MySQL.
Is this possible? Or more of a problem?
...more >>
log file Posted by Sam at 10/15/2006 7:00:15 PM how can i automate decreasing the log file size?
thanks
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |