| 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 how to troubleshoot connection problems Posted by Selden at 6/21/2006 3:04:21 PM I have a server (running sql server 2000) used by several offices. The
connect to it over the Intenet, using ADO.Net. This has been working for
more than 6 months, without any apparent problems.
For the past couple of weeks, we've been having intermittant connections.
Here's one symptom:...more >>
how to trace all executed ,slect,alter and update from sql server 2000 Posted by ch.adilaziz NO[at]SPAM gmail.com at 6/21/2006 2:15:23 PM HI !
I need help to know that how can i trace or capture all Tsql statements
(slect,alter and update ) runs on my server on daily
bases.................................
...more >>
Restoring 90+ Databases to new SQL 2005 Server Posted by kambizg NO[at]SPAM cox.net at 6/20/2006 5:09:34 PM Hello:
We have a new SQL 2005 server. We have an existing SQL 2000 Server. The
existing SQL 2000 server has about 90+ database that we need to restore
to the new SQL 2005 server.
Does anyone know of the best efficient way to do this?
Thank you. Kam.
...more >>
IF within CASE Posted by gg NO[at]SPAM xemaps.com at 6/20/2006 6:34:13 AM Why does this work:
declare @x char(1)
set @x = 'a'
print case @x
when 'a' then
case when 50 > 40 then
'50>40'
end
end
But this gives a syntax error on the if statement?
declare @x char(1)
set @x = 'a'
print case @x
when 'a' then
if 50 > 40
'50>40...more >>
why are insert statements not allowed in user defined functions? Posted by Dica at 6/19/2006 4:33:15 PM i've got a function that attemtps to look up a region id by name. if it
fails to find the region name in the table, i'd like the function to add the
missing record to a separate table for later review. any attempts to add an
insert statement within my function fail with an err msg about insert
s...more >>
Restore 32-bit system DBs on 64-bit SQL 2005? Posted by bill_sheets NO[at]SPAM hotmail.com at 6/19/2006 10:05:08 AM I have a 32-bit installation of SDQL Server 2005, and I am preparing to
reinstall the system with 64-bit OS and SQL Server 2005.
Can I restore the master, msdb, and model databases from backups made
on the 32-bit version? User databases should be fine, but if I can't
restore the system DBs, t...more >>
SQL Server 2005 Developer Edition Posted by Snake Eyes at 6/16/2006 11:54:51 AM I have installed the SQL Server 2005 developer edition, all components, and
it seems to be running fine. I see the configuration IDE only.
However, I see no Enterprise Manager (Visual Studio, etc). What am I
missing?
Thanks
Snake Eyes
...more >>
Server Domain Name Change Posted by MeTed at 6/16/2006 11:35:20 AM Hi All,
Does anyone know the potential impact on SQL7 (on NT4) if it is joined to
another domain (along with the users, of course).
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How to code Oracle 'to_date' function in Microsoft SQL Posted by Red at 6/16/2006 3:41:06 AM How do you code the Oracle 'to_date' function in Microsoft SQL.
Thanx...more >>
Disable the service responsible for listening port 1434 Posted by scottzuehl NO[at]SPAM gmail.com at 6/15/2006 5:00:02 PM Is it possible to disable the listener on port 1434? All our client
connectivity is defined with the server name and port and we do not
allow our clients to do a lookup on the sql server. What do I need to
do to disable this listener?
thx
...more >>
.NET SqlClient Data Provider generating long durations Posted by John Bailo at 6/15/2006 3:43:09 PM
I'm doing a profile on my SQL Server to see if I can eliminate any long
running statements, and periodically, I see an entry for ".NET SqlClient
Data Provider". The durations for it are very long, the example below
shows 386 seconds!
I would think that whatever these are they are "gummi...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |