| 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 |
Using Transaction scope Posted by AnikSol at 10/31/2006 10:54:02 PM Hi,
VB 2005 Prof, SQL server 2005, Windows application
- I am using transaction scope and within this scope I am passing multiple
SQL statements to the command.text
On executing, all is well.
But noticed that in case there is SQL server time out, then the transaction
doesn't fail.
Say...more >>
Begining Queries Posted by Aaron at 10/30/2006 11:15:55 PM I am a novice SQL guy so you all take it easy on me.
I am trying to run a query and one of the columns of my has values that is
referenced in another table, i.e. for EmployedStatus I have a bunch a
numbers from aother table. I go to that table to see what the numbers mean
and there you go....more >>
Out in email. Posted by Rogers at 10/30/2006 8:20:28 AM I am using extended stored procedure xp_sendmail to send the email now my
question is, is there any way in can write the out of following query into
one file and send it to through email? or output directly goes to email..
restore FILELISTONLY from disk = 'c:\fullpath.bak'
Thanks
...more >>
Users do not get disconected Posted by Mike_T at 10/30/2006 12:00:00 AM Hi,
When detaching my db a msg came back skating that I have over 300
connections to it. I know at the moment I was the only one connected so, for
some reasons, user process ids are not recycled (or eliminated) when the
user disconnects from the db. Is this normal? If not, how do I ensure t...more >>
VB 2005 Insert records into multiple tables Posted by AnikSol at 10/29/2006 12:00:00 AM Hi All,
Not sure if this is the right forum to post this!
VB 2005 Prof, SQL server 2005, Windows application
Scenario: In a winform application, using SQL server authentication method
(not windows authentication), we have a text/binary file containing multiple
SQL statements (insert,update,...more >>
Default value of a GUID field?! Posted by Aaron Bertrand [SQL Server MVP] at 10/26/2006 11:04:22 AM Fix your system clock, Leon!
...more >>
Default value of a GUID field?! Posted by Leon_Amirreza at 10/26/2006 12:00:00 AM I have a column named "ID" and its type is "uniqueidentifier" in SQL Server
2005 Express.
this column is the primary key and its default value is "newid()" in SQL
Server.
I have generated a DataSet in C# that has this column but its default value
is DBNull what can I do to make the default va...more >>
One workstation remote SQL Server 2005 connection fails Posted by Matt Soukup at 10/25/2006 9:26:03 AM I have a workstation running SQL Server 2005 with mixed mode. I have enabled
remote access and allowed access through the firewall. All of the remote
workstations can connect, but one. I have tried to to an ODBC test connect
and it gives me the following error.
Connection failed:
SQLState: '...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Linked Server object Posted by BMW at 10/18/2006 3:43:02 PM I found the article abount linking exchange server with Sql 2005
EXEC sp_addlinkedserver 'exchange',
'Exchange OLE DB provider',
'exoledb.DataSource.1',
'file:\\.\backofficestorage\localhost\public folders'
I didn't see the 'Exchange OLE DB provider',
'exoledb.DataSource.1',
Do you h...more >>
Cannot connect to remote Sql Server 2005 Posted by David Thielen at 10/15/2006 1:05:01 PM Hi;
I installed the dev version of SqlServer 2005 and can access it fine on the
server it is on. And the properties say it allows remote connections.
But SqlServer Management Studio cannot connect from my workstation to the
server. And I cannot connect using ADO.NET or JDBC.
SSMS says "...more >>
Error linked server query after installing SP4 on SQL 2000 Posted by Nic at 10/10/2006 10:25:02 PM Hello
SQL 2000 SP3a run fine with an linked server query like
select * from openquery( linkedOlapServer, .. here is the MDX ...')
After installing SP4 build 2039 this query fails with error:
Server: Msg 7302, Level 16, State 1, Line 1
Could not create an instance of OLE DB provider 'MSOLAP'...more >>
Connectivty problem from NON domain users Posted by Ido friedman at 10/10/2006 3:25:02 AM I have a problem esteblishing a connection to a SQL server with a SQL user,
while I am logged to the computer with a local computer.
Any domain account can has no problem.
What can ause this?
Thanks in advance,
Ido Friedman...more >>
identity on / off Posted by David Kwon at 10/9/2006 12:32:59 PM does anyone know syntext to turn on / off Identity field? I usually do this
via EnterpriseMgr but I want to do this via SQL.
...more >>
Non domain user recive acess denided error Posted by Ido friedman at 10/9/2006 7:10:02 AM I am trying to run a VBScript that uses a SQL user to access a 2000 SQL SP4
clustered instance.
The script runs successfully only when I am logged on with a domain account.
What can the reason for this be?
Thanks in advance,
Ido Friedman...more >>
Non domain user receive access denied error Posted by Ido friedman at 10/9/2006 7:07:02 AM I am trying to run a VBScript that uses a SQL user to access a 2000 SQL SP4
clustered instance.
The script runs successfully only when I am logged on with a domain account.
What can the reason for this be?
Thanks in advance,
Ido Friedman...more >>
Login to SQL with non domain account Posted by Ido friedman at 10/9/2006 7:01:01 AM I have a problem accessing a SQL instance from a VB script that uses a SQL
user, and is executed with a local computer user.
When I use the same VB script while logged on with any domain user it
executes successfully.
All SQL tools like query analyzer and enterprise admin have not problems...more >>
Image , text , ntext.. Posted by Rogers at 10/6/2006 2:47:55 PM Is there any way I can comapre the new value of text, ntext and image with
the existing text, ntext and image column value. I have to do validation if
that text is not exist then it should inserted otherwise not..
Anyway I can do this validation?
Thanks in advance.
...more >>
problem using SQL Server 2005 database from C# application through ATL COM dll.... Posted by Asko Telinen at 10/6/2006 12:36:29 AM
Hi all.
I don´t know if it is right group but maybe you guys be able to show me
a right direction. And im sorry, if i crossposted this message to
several groups.
Ok ,the problem is following:
We have a large ATL COM dll, which is used as common interface for our
database and it is u...more >>
How to get Enterprise Mgr on pc? Posted by kwl88 at 10/4/2006 12:29:02 PM I have installed a 64-bit SQL Server 2005 standard edition onto my database
server. I now want to install the client onto my pc.
How do I install onto client pc?
Thanks!...more >>
windows XP Client for sql server 2000 Posted by jaredwetmore at 10/3/2006 8:14:02 AM do i need to install any Ms client software to connect to a sql server 2000
machine ? Or does windows XP sp2 do it out of the box ?
any help here would be GREAT !!! thanks in advance !
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |