We are building a MS SQL server. It will be used internally only, accessed by a .NET application. The database needs to have encrypted columns and all connections to the server need to be en...
Hello,
I am writing a servlet to connect to database. I am using SQL server 2005 and JBOSS application server, kindly let me know what are the steps of connectivity. I am not sure to be usi...
I was installing SQL2005 and I got the option of "default" and option of "creating an instance" of sql server.
I chose the Instance and named it whatever.
What's the difference between t...
Dear Sir,
I am using the following store procedure which is updating data after select path from front end (VB 6), in office i am using MS-Office-2007
ALTER PROCEDURE [dbo].[FuelTableUpda...
Our company has been running reporting services for a couple of years now all on one production server (Server A). We have now added a second physical server (Server B) with SQL Server 2005 t...
have data I'm reading for export to a text file that has
as part of the export dR("rowdata")
which equals something like
blah...blah...blah<br><br>blah...blah...blah<br><br>blah...blah.....
SQL Server 2005 - trying to connect to it from an asp/vbscript page
The Server Name is DHS5195 and the SQL Instance is DHS5195A
(The default instance is a SQL 2000 install I will eventuall...
Can anyone tell me of an easy tool/way(500000 rows of data so manually wouldnt do it) of comparing data moved from an access table to a Sql 2005 database ?
Each row and each field to be com...
My simple query:
select count(A200707.lot) as use_recordcount from auction
...returns error:
The multi-part identifier "A200707.lot" could not be bound.
All I'm trying to do is get...
In a stored procedure with SQL Server 2005, how do I write a loop that is gonna loop while a comma-delimited string contain data?
When the loop is executing, it is necessary that we can re...
Hello All,
I have a report that the user selects a date as a parameter. The report then generates the data for the month and year of that date that was picked. The day they picked does n...
I have a small Update Statement that I am using to update a table from a temporary copy of the old table but I am getting the above error and I haven't not found much help on it. Thanks!
We are moving our data layer from a 32-bit SQL 2005 cluster to a 64-bit SQL 2005 stand-alone. In order to minimize downtime of our production environment, I setup mirrors for the production d...
I just upgraded my system to SQL 2005 and x64 windows. My Connection string did not work so we switched to SQL Native Client.
This code suddenly did not work anymore.
THe stored Procedur...
dbcc memorystatus show me below info, which committed and target are getting the same value
Buffer Counts Buffers
------------------------------ --------------------
Comm...
Hi,
I had killed this process which caused the major blocking on my db, look at the command from the results I really have no idea what it is
SPID = 67
DBID =9
DB_NAME = DPC
Login_time ...
Can anyone help?
Our SQL server 2005 database has a dbo.tblpupil table with various fields within it; i.e. PupilUserID, int - PupilSurname, varchar(128) - PupilClass, varchar(50)
What i ...
I have about 30 computers that need to have an ODBC connection set up to a SQL Server 2005 database using SQL Native Client.
Is there a way I can remotely install this with a login script o...
I make changes to my database and the do not show up from the website until i publish it.....I need help and i will give you anything that you need to answer my question
