Recent content by hvisionexpo

Thanks for quick reply. presently am using sql 2000 but in the next month i will be moving to sql 2005. if there is something new in 2005 to helpwith this i could use those features. here is the current version info: Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05...

is there a way to encrypt values in the database? i need to store user id, password, credit card info in the database and would like to store encrypted with a key so if anyone has access to the db cannot just read it unless they know the key thanks

Ok I was able to set it to single-user mode by going to properties. But now I cannot run the SQL since it rejects th connection. In order for me to use repair_allow_data_loss option it wants the DB in single user mode and if I switch to single user mode I cannot get the SQL SUery analyzer...

CHECKDB found 0 allocation errors and 2 consistency errors in database 'mydb'. repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (mydb). DBCC execution completed. If DBCC printed error messages, contact your system administrator. What command can I use to...

DBCC CHECKDB ( 'mydb' , NOINDEX ) gave these 2 errors: able error: Object ID 548197003, index ID 0, page (1:7997), row 1. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 8224 and 1106. CHECKDB found 0 allocation errors and 2 consistency errors in table 'hcfa'...

I have a client-server app using SQL 2K. 1. With one of the databases it keeps giving this error when I perform a select. SQL 2000 - SQLSTATE = 08S01 Connection failur DB error code = 999 2. If I open a table in SQL Enterprise it gives an error: [Microsoft][ODBC SQL Server Driver][SQL Server]...

updated template.ini contents: [Options] INSTANCENAME=MY_INSTANCE SQLBROWSERACCOUNT=NT AUTHORITY\NETWORK SERVICE SECURITYMODE=SQL SAPWD=music UPGRADE=SQL_Engine SQLBROWSERAUTOSTART=1 RSCANINSTALLDEFAULT=0 RSCONFIGURATION=FilesOnly RSSQLLOCAL=0 I get an error that this file is...

I need to create the script to upgrade the current named instance of sql server 2000 desktop engine to sql server 2005 express edition. I am having difficulty preparing the template.ini and would appreciate help. When i use this template.ini it logs an error that this instance already exists...

Where do I find the setup files needed to redistribute sql server express installation files? I downloaded the SQLEXPR_ADV.EXE but the files disappear as soon as you cancel the installation. I need the sql server setup files to package with my program for distribution. I will be editing the...

i am working on upgrading te clientsand server computers from 2000 t0 2005. i can find the version of sql server running on th server by @@version but ho do i find the version of client connctivity components the computer has installed in order to ugrade? 1. somehow i need t know whether to...

i have clients that are using 2000 MSDE named instance in network environment and I need to upgrade 1. sql server 2005 Express edition on the server computer 2. client drivers for the the client computers to be able to connect to it. It also needs to have .NET 2.0 as a prerequisite. Is .Net...

with SQL Server 2005 install the name of the instance does not appear in Add or Remove Programs. In 2000 each instance was listed seperately and could be removed without affcting others. Since 2005 does not list the insance name does removing SQL Server remves all instances of SQL Server? Also...

Is there a way to TURN-OFF this error "Arithmetic overflow error converting float to data type numeric." so I an perform insert from a float column to numberic. I do not care if it gets truncated. If not, Is there an alternate solution to insert the values from one table to another with...

Is there a way to query the verson of SQL Server the user is running? e.g. SQL 2000 or SQL 2005 ---------------------------------------- Presently we have app deployed in 2000 and plan to silently upgrade users to 2005. would like to chek whether they need to be upgraded ornot. some clients...

What is the default username and password when oracle is installed? How can I specify the servername to use when using command-line? Thanks