|
|
|
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 |
Help needed ! Posted by Noor at 9/29/2007 3:21:12 PM
I would appreciate if any one can help me out regarding the following
situation.
I created one database that has sensitive information in it so that I have
implemented Symmetric AES_128 Algorithm implemented and changed all the
stored procedure to first open the Symmetric Key and us...more >>
A transport-level error when calling SqlCommand.ExecuteNonQuery() Posted by Roy at 9/28/2007 1:12:01 PM I have a stored procedure with some input parameter and one output parameter.
I use SqlCommand and SqlParameter as following
///Set some imput parameters here
parameter = cmd.CreateParameter();
parameter.ParameterName = "OutputParameter";
parameter.DbType = DbType.String;
parameter.Size =...more >>
Sql Native Client - Can't reach by instance name Posted by Kevin Chambers at 9/26/2007 11:31:29 PM Hi there--
I'm connecting to SQL Server Express from MS Access via ADO on a
number of older workstations. Of three workstations, two connect just
fine with a connection string like this:
Provider=sqlncli;Network Library=DBMSSOCN;Initial Catalog=MyDb;Data
Source=server\sqlexpress;Integrated S...more >>
SQL 2005 Compact Edition - Derived tables Posted by arothberg at 9/26/2007 12:32:00 PM I would like to know if derived tables are allowed in SELECT statements in
Compact Edition 3.1
For example:
SELECT * FROM (SELECT * FROM SomeTable) d
I have some complex queries which require using dervied tables. This
doesn't appear to work with my 3.1 installation and I get the error...more >>
Symmetric and Asymmetric Posted by Rogers at 9/24/2007 3:45:43 PM Dear Professional,
What would be the best answer if I ask when we use Symmetric Encryption Key
and Asymmetric Encryption in terms of SQL Server 2005 database.
Thanks in advance
...more >>
Access Project Deployment Posted by MUSIWA at 9/19/2007 2:38:02 PM I appologise if this is silly but I am trying. I upsized my access mdb
database to access project (adp) sql. It works very well now. my is I now
copy it and I palce it in myclients and if I am logged into the clients the
program works just fine but if my users are logged in it cannot connect t...more >>
A full log Posted by KHATER at 9/17/2007 6:02:03 AM In SQL server 6.5, I've got the message (the application log file is full)
after restarting the server and before login. this makes the working database
useless and marked inaccessible. Please I need and advice how can I solve the
problem.
Thank you...more >>
Disable Identity Posted by Rogers at 9/14/2007 5:54:51 PM I want to disable the identity property on one of my column, can any one
tell me how I can do that from query analyzer, I can do that from Enterprise
Manager but I want to do through query analyzer?
Plz advice
Thanks
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL 7 & Server 2003 Posted by Neil at 9/13/2007 12:00:00 AM Has anyone heard of any problems running SQL 7 under Windows Server 2003?
We're upgrading to 2003 and are wondering if we can keep SQL 7 with the new
OS.
Question 2: If we upgrade SQL to SQL 2005, can I run our database in SQL 7
mode? Or would it be better to just convert it to SQL 2005?
...more >>
Why do I have to enable File and Printer sharing to connect through the XP firewall? Posted by Keith at 9/10/2007 2:07:41 PM Hello,
I have a client app that connects to a remote instance of SQL Server 2005
Express. The client uses the SQL Browser to locate available SQL instances.
The SQL instance has Shared Memory, Named Pipes, and TCP/IP turned on, and
TCP/IP is configured to use a static port (5721).
The ...more >>
Access complains of duplicate key Posted by David H. at 9/10/2007 12:30:05 PM Our Access 2000 database (a front end to MSSQL2000 data) has two main tables
with a 1-1 relationship. Call them Client and Assessment. (Why? Mostly
just too many fields to fit in a single table.)
The main data entry form has lots of tabs; the first two tabs look at data
in Client, other ...more >>
SQL Server 2000 timeout Posted by Andy Baker at 9/10/2007 12:00:00 AM I have a VB.NET application using SQL Server that I have been developing
using a test database. Recently I wrote a program to convert data from a
customer's old DOS based system to an SQL server database, in the same
format as the test system. When I had finished converting (it ran for about
...more >>
SQL server connection problem Posted by KHATER at 9/9/2007 6:26:01 AM
Problem description
==============
- I have 4 clients and 1 server (SQL server)
- 3 clients are Monitoring console 1 client is operation console
- Monitoring console collects some data from the control unit and
store them into the Sql server
- The operation console...more >>
SQL Server 2005 Connectivity Posted by Noor at 9/7/2007 3:26:16 PM Dear Professional,
I would really appreciate if any one help me out.
I have a Windows 2003 RS Service Pack 2 Server that has SQL Server 2000
installed on Default instance and SQL Server 2005 Named Instance.
I enable all the Protocol, Add the SQLBrowser, SQLServ.exe into Exception
List in ...more >>
Best connection management Posted by Hornet77 at 9/7/2007 12:00:00 AM Hi all
I'm developing a software written in c# (.NET 2.0) with a SQL server
2005 database. I have 3 modules that need to access database:
- a simple ASP.NET website receiving event from remote devices via https
calls
- a windows service running 24/7 that act as a server
- a winform a...more >>
SQL Server 2005 port? Posted by Rogers at 9/6/2007 4:51:33 AM How can I change SQL Server 2005 port?
...more >>
SQL Server 2005 Client on Windows XP Posted by Rogers at 9/6/2007 3:15:33 AM I have a SQL Server 2005 Client on Windows XP and tried to connect SQL
Server 2005 it connect perfactly fine. I also have a SQL Server 2005 into
Windows 2000 and when I tried to connect from Windows 2000 to Database
Server, it gave me connection error. I don't know why its not giving me
thro...more >>
Please advice Posted by Rogers at 9/6/2007 1:37:05 AM I can't connect from client to Server.
Here is the Server configuration Settings:-
sp_configure
Min Max Config Run
allow updates 0 1 0 0
clr enabled 0 1 0 0
cross db ...more >>
Disaster recovery Posted by Rogers at 9/6/2007 1:27:47 AM Just thinking about disaster recovery, if I want to move the database into
another server then how I get the Master Key, Certificate and Symmetric
Keys? if I restore into another box will it work or I have to to do couple
of configuration settings?
Thanks
...more >>
Error: AES128 Posted by Rogers at 9/6/2007 12:55:23 AM I am using Windows 2003 R2......
CREATE SYMMETRIC KEY CIS_Symmetric_Key
WITH ALGORITHM = AES128
ENCRYPTION BY CERTIFICATE CISEncryptionCertificate
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near 'AES128'.
select @@version
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel ...more >>
Know the view name Posted by Rogers at 9/6/2007 12:30:03 AM I want to create DDL trigger like if any view create in the database I want
to know the name of the view.
like
CREATE trigger trg_SelectViewRights on Database
FOR CREATE_VIEW
AS
BEGIN
SELECT OBJECT_NAME()
END
Can you correct me?
Thanks
...more >>
Can't connect through IP Posted by Rogers at 9/3/2007 9:44:18 PM Dear Professional.
I installed SQL Server 2000. I can registered SQL Server in Enterprise
Manager as a [local] but when I tried through IP it gave me an error. SQL
Server doesn't exists or access denied. Plz advice.
Thanks
...more >>
Server stops responding Posted by Altaf Al-Amin Najwani at 9/2/2007 3:12:01 AM Hi All,
I am running SQL Server 2005 SP2 (Without SP1) on Windows 2003 Machine. I am
facing a very strange problem. Sometimes the database stops responding, In
this situation no user from my web application can connect to database. But
If I go to server and open connection by management stu...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |