| Groups | Blog | Home |
|
March 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 |
Impossibly remote connections to SQL 2005 express Posted by gregory.white NO[at]SPAM ntlworld.com at 11/29/2006 9:05:30 AM I have spent the best part of 4 days trying to connect to SQL 2005
express from an winforms app! Yes , I have checked surface config and
TCP/IP blah blah ...
I have trawled the net and spent countless hours on MSDN and many have
tried to help. I have changed the passwords to strongly typed... ...more >>
Locking... Posted by Rogers at 11/22/2006 8:44:18 AM Can any one give me any URL where I can find the locking Hint with example.
I have a two query in one my stored procedure and in the that its returning
session ID to users like.
Set @SessionID = (Select TOP 1 SessionID from Session)
UPDATE Session
Set UsedYN = 1
where SessionID = @Sessi...more >>
Alert in Email !!! Posted by Rogers at 11/22/2006 8:38:23 AM Dear Professional,
I am using one extended stored procedure to send email from SQL Server. Now
the question is how can I email my self from SQL Server if CPU usage greater
than 30% or available memory greater than specific value,
Can any body guide me regarding that?
Thanks
...more >>
How to avoid entitized characters in XML column Posted by KM at 11/22/2006 12:27:02 AM Hi,
I inserted data with whitespace in XML column and the space is
stored as entitized string "& # x 2 0 ;".
MSSQL seems to entitize some characters during serialization. Some
characters are &, <, >, white-space, TAB, linefeed, carriage return, and
surrogate pairs and so on.
I found the d...more >>
Sql retornar meses Posted by Marco A. at 11/21/2006 12:00:00 AM preciso fazer uma consulta que me retorne a soma de valores dos meses e anos
como segue abaixo independente de ter valores ou nao
campos q tenho. datadevencimento, valorpago.
ex. se nao tive nada em janeiro de 2000, deve aparecer 0,00.
obs. nao sei o ano inicial vou pegar a min(datadevencimento)...more >>
uninstall MS SQL 2000 manually Posted by Daniel at 11/14/2006 7:11:02 PM Hi,
I have installed MS SQL 2000 with only the connectivity tools.
I discovered that there is not entry of the MS SQL in the Add/Remove Program
when I would like to unistall it.
When I use a audit software to audit that particular pc it shows that MS SQL
is installed.
How can I unins...more >>
Using generated script in SQLCLIENT Posted by Al Christoph at 11/13/2006 4:30:01 PM I have a script for my database that works wonderfully in SQL Manager Express.
I'd like to feed it to sqlclient.executenonquery. But as a mimimum all those
GO statements get in the way.
Is there any way of using the generated script short of massaging it by hand?
--
Regards,
Al Christo...more >>
MS Access 2000 and SQL 2000 Posted by Sam at 11/8/2006 7:56:01 PM I have a user application that runs on MS Access 2000. On one client PC, the
user's PC log in and got the following error:
17[Microsoft][ODBC SQL Server Driver][DBNETLIB]AQL Server does not
exist or access denied.:53[Microsoft][ODBC SQL Server Driver][DBNETLIB]
ConnectionOpen(Connect())....more >>
Don't see what you're looking for? Search DevelopmentNow.com.
large query Posted by Aleks Kleyn at 11/7/2006 12:26:24 AM I have query from SQL server 2000 which returns from database very large.
However I show client only 20 records per page. I need to find way which
allows to get from database only what I need (like top 100). Response from
database about 10mins which is not acceptable.
...more >>
New install on client side Posted by Ana_T at 11/6/2006 8:56:00 PM Hi,
I have a SQLServer 2005 Enterprise Edition installed on a server running
w2003. I'd like to install the Business Intelligence Development Studio to
control the server on a xp machine. How do I do it? The CD forces me to
install the engine on the xp but I don't need it.
TIA,
Ana
...more >>
SQL Server 2005 Screensaver Posted by Maurice at 11/6/2006 2:28:02 PM Presently dealing with the trial version and did not see one . Is there an
authentic SQL 2005 Enterprise Screensaver? Please advise...more >>
import file Posted by sara at 11/6/2006 1:29:00 PM Hi All,
Is there any way to import a text file into a table in sql server 2005
prefarabley in its gui (MS SQL Server Management Studio)?
Thanks.
...more >>
Can I set multiple filters? Posted by Todd at 11/5/2006 4:08:01 PM I am using SQL Server 2005 Express Management Studio. I want to put in
multiple filters for stored procedure. Example: where sp name contains
'spFNP or spNGFM'. Is this possible? If so, what is the syntax?
Also, is there a way to save filter between sessions?...more >>
Script Posted by Erencan SAÐIROÐLU at 11/2/2006 4:23:28 PM Hi Folks,
I need a script that it'll changed varchar field to nvarchar a table which i
pass it's name via parameter.
I generated it but it'll raise exception when a field has foreign key etc...
I don't want to spend more time to this work. Do you have a script like
this? Or program?
If you...more >>
Cannot Create a Relationship Posted by Greg at 11/2/2006 2:37:02 PM I have three tables imported from Access that had relationships with
eachother and had Cascading Deletes set to TRUE. The tables related in a
simple manner.
tblPackingList.PackingListID to tblPackingListPart.PackingListID
tblPackingListPart.PackingListPartID to
tblPackingListPart.PackingL...more >>
sp_executesql Posted by Erencan SAÐIROÐLU at 11/1/2006 7:07:34 PM Hi To All,
I have a question. I execute two query in seperate times with sp_executesql.
The first query executes with parameters, the second quert executes without
parameters.
In normally the first query (With parameter) has to execute too fast than
second query. But the first query's perform...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |