|
|
|
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 |
Newbie, True and False Posted by tclancey at 3/30/2007 8:05:45 PM Hi All.
First time working on an SQL database. I'm able to create all my tables and
fields without errors. I can work eith the back end pretty well, but I
can't work out True or False Fields/Columns.
If I try:
Insert Into MyTable (value1, value2) values (true, false);
I'm told that t...more >>
Is there a way to have an dynamic identity column? Posted by ThunderMusic at 3/29/2007 10:08:08 AM Hi,
What I want to do is a Select on a table that adds a dynamic column like
let's say Select T.*, GetDate() From MyTable T; My example is not very
useful, but it's just so you get the point... Now, I want the select to
create a simili-identity column that will set an incrementing value to ...more >>
How to: Install Report Designer Posted by joju at 3/28/2007 2:26:04 PM Hi I wanted to know the steps to install the report designer...
I have the foll. installed on my machine
ASP.NET 1.1
Version > SQL Server 2000 SP3a
Visual Studio .NET 2003
Windows XP OS
i WANT TO USE THE REPORT DESIGNER ON THE CLIENT TO DESIGN REPORTS THAT COME
INTEGRATED WITH THE IDE itself...more >>
Licensing through a TS Posted by Paul Simpson at 3/27/2007 5:49:53 PM Scenario:
We have 35 Citrix client machines needing to connect to SQL Server 2005 Std.
Question: Do I need to purchase 35 User CALS. I think I know what the answer
is but I would like confirmation please. As everybody knows the licensing
aspect of microsoft can drive people to insanity....more >>
SQL Server 2005 backup Posted by Rogers at 3/27/2007 10:03:43 AM Just wondering, If I take the SQL Server 2005 backup and can it be
restoreable in SQL Server 2000?
...more >>
Text column in select query Posted by Rogers at 3/26/2007 12:47:56 PM I have a text column table and that contains 3000 records but when I try to
use top 10 query and include text column it take 10 minutes and when I
remove the text column from the select query it takes a second, any idea how
we can speed up the query if I include text column in my list.
...more >>
SQL2005 License Limit... Posted by Rich at 3/25/2007 12:00:00 AM Say you have an SQL2005 Workgroup Edition server with per user licensing,
and lets say you have 5 user cals.
What happens when a 6th user tries to connect?
--
Rich
...more >>
connection issue from our developer Posted by Lynn at 3/22/2007 10:33:45 AM Hi,
SQL 2005 EE is installed on W2k3 box and firewall is off in this server.
From my client machine, my window account and that developer window account
all can login into this server with ODBC, sql client, telent to 1433 or VS
connection. But, this developer can't login to SQL server fr...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Agent services Posted by Ana at 3/21/2007 8:24:42 PM Hi,
How to activate the Agent on SQLExpress05?
TIA
Ana
--------------------------------------------------------------------------------
Estoy utilizando la versión gratuita de SPAMfighter para usuarios privados.
Ha eliminado 3003 correos spam hasta la fecha.
Los abonados no tienen este ...more >>
SQL Server Courses Posted by VCM Network at 3/20/2007 7:58:16 PM I located the following titles and dates of courses being held in Chicago:
2071 Querying Microsoft SQL Server 2000 with Transact-SQL 04-05-07
2071 Querying Microsoft SQL Server 2000 with Transact-SQL 05-14-07
2071 Querying Microsoft SQL Server 2000 with Transact-SQL 07-16-07
2072 Admin...more >>
VS2003 client with SQL Server 2005 server Posted by delard at 3/20/2007 12:11:11 PM Hi,
I'm about to start an evaluation of SQL Server 2005. The development
platform we use is Visual Studio 2003 - ie .NET 1.1.
I understand that Visual Studio 2005 probably integrates better and offers
more functionality - but we aren't doing that migration for a while yet. Is
it still po...more >>
Using "Windows Authentication" on a Home Network Posted by Robin Bowning at 3/17/2007 4:02:14 PM Hi everyone,
I'm quite new to SQL Server so maybe this is an easy question but I haven't
found the answer after 3+ hours of Googling and experimenting.
I have a simple set up - two computers named HELEN and DELORES, both running
Win XP Pro, SP2. These machines are connected via a home netw...more >>
Secruity Tool Posted by Rogers at 3/16/2007 12:37:19 PM Dear Professional,
Is there any security tool available which validate all the database stored
procedures
Thanks
...more >>
Multiple Servers in ODBC Client Setup Posted by Richard K at 3/16/2007 4:47:05 AM OK, something weird is happening.
I have a standard Windows XP client and I am trying to set up a simple ODBC
entry. So I go to Control Panel/Administrative Tools/ODBC/System Tab. From
there I create a new ODBC entry connecting to a SQL Server. I enter in the
name of my ODBC and a descri...more >>
How to configure SQLExpress on a workgroup Posted by Earl at 3/15/2007 12:09:19 PM I recently deployed an app with SQLExpress2005 as the backend. Despite
testing it here on my dev network, this was my first opportunity to use it
in a workgroup environment. I had to really jump through some hoops to get
connectivity between the app and the SQLExpress database. I'm asking for ...more >>
SQL Native Client Posted by Francois PIETTE at 3/13/2007 3:27:40 PM I'm currently playing with SQL Server 2005. I deployed the server on a
W2K-Server. It works fine.
I have deployed two clients on computers running XP-Pro, using SQLNCLI.MSI.
No problem.
I have done the same deployment on a computer running W2K using the same
SQLNCLI.MSI. That computer is unable...more >>
Configuring protocols in SQL Native Client Posted by Francois PIETTE at 3/13/2007 3:17:40 PM When SQL Native Client has been installed on a client computer using
SQLNCLI.MSI, the Configuration Manager is not installed. Hence the question:
How do we configure the protocol to be used to connect to the server ?
--
Francois PIETTE
http://www.overbyte.be
...more >>
SQL Express on a small network Posted by Earl at 3/13/2007 1:53:56 PM I have an app that is on a small network. The backend is SQL Express 2005.
The network is connected through a router without a server. Each of the
computers on the network appear in the Explorer browser of the other
computers -- they can share files and printers.
However, when I try to add ...more >>
OLE DB Services and SQL Native Client Posted by Michael Tissington at 3/13/2007 8:40:37 AM Is the option OLE DB Services = -4 still valid in the connection string with
the SQL Native Client ?
...more >>
SQL Native Client and SMux Provider Posted by Michael Tissington at 3/12/2007 10:43:48 AM I have recently changed my application from using SQLOLEDB to SQLNCLI.
Occasionally I'm seeing an error "SMux Provider: Physical Connection is not
usable"
What does this mean and where does it come from ?
Thanks.
...more >>
Can't conenct to sql 2005 Posted by Simon Renshaw at 3/9/2007 3:16:34 PM Hi,
Can you connect to SQL 2005 if you're not part of the domain the server is
installed in?
I installed the client and it can see my SQL 2000 server but not the SQL
2005 server.
Is it because the laptop I installed it on is not part of the domain?
If so, beside having it join the do...more >>
Connecting tables from a different database to an application Posted by TLD at 3/9/2007 11:31:32 AM I have an application using an Access 2003 project connecting through ADO
which must refer to a table in a SQLServer 2000 database other than the main
database. When I connect, I get the data but the recordset is not updatable.
I can create a view in the main SQLServer database that makes the...more >>
Express to Standard Posted by Chanaka at 3/8/2007 11:38:02 AM If I have sql 2005 express installed with a data in it, how can i upgrade
that to SQL standard 2005 without bringing the database down?
Thanks...more >>
SQL Server 2005 Native Client Installation Problem Posted by SafetyLabel at 3/7/2007 10:13:31 AM I have a question concerning a SQL Server 2005 Native Client Installation. I
have a Windows 2003 Server running SQL Server 2005, and I'm trying to install
an instance of the SQL Server 2005 Native Client on a Windows XP Pro SP2 box.
Both machines are hooked up to a domain.
Upon running the ...more >>
dual NIC cards SQL Server does not exist Posted by RedBear at 3/7/2007 7:22:03 AM [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied
I have two NIC cards on my client machine.
NIC #1 is the corporate network where my SQLServer resides.
NIC #2 is for a local device accessed via TCP/IP.
When I try to open a connection to the corporate datab...more >>
Path to exe Posted by Michael Tissington at 3/3/2007 9:45:29 AM I'm trying to automate opening the firewall for an instance of SQL.
For a given instance of SQL how do I find the path to the executable ?
...more >>
Change existing application to use sqlncli Posted by Michael Tissington at 3/2/2007 3:17:37 PM I have a large application that currently uses SQLOLEDB as the provider.
The application needs to connect to SQL 7 thru SQL 2005.
I have tested changing the provider to SQLNCLI and everything still seems to
work.
I have a couple of questions ..
1) Is it really this easy ?
2) Can I sti...more >>
Licence question Posted by manicguitarist at 3/2/2007 6:13:28 AM Not sure if this is the correct group - but couldn't find a specific SBS
managed group - and as this relates to the SQL component of SBS it seemed a
good place to start.
A client of mine is running SBS 2003 R2, with 15 CALS - they have 12 staff.
Their server has a public IP address, and th...more >>
SQL OLE DB provider problem (sqloledb.dll) Posted by Peter Hemmingsen at 3/2/2007 12:00:00 AM Hi
On a new PC I've installed Win XP Pro with SP2 and SQL Express 2005.
According to the registry (and Microsoft) this should include the latest
MDAC 2.8. I also have an SQL Server 2000 on the network. However when I use
Microsoft Data Link and select the "Microsoft OLE DB Provider for SQL ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |