• Finding the public key in an asymmetric encryption on SQL Server

    How do I know what the public key is for a given private key in an asymmetric encryption on a SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to write Bcp command to insert data in to a table

    Hi, I have a file which contains the data 2:23:3#1:2:4#2:3:5 i have to insert the data in to the table in multiple rows from a single file as #--indicates to be inserted in next row : --indicates next column column1 column2 column3 2 23 3 1 2 4 2 3 5 I need to use BCP. Can any one let me know how...

    GIG240 pointsBadges:
  • Can we migrate already encrypted data from SQL Server 2000 to MS SQL Server 2008

    I have encrypted data in MS SQL Server 2000. I want to migrate in MS SQL Server 2008. I have migrated successfully through the attach/dettach process but when I am trying to decrypt the data. is it giving different result or value. is the right process to migrate the encrypted data? Please suggest...

    Amit1may5 pointsBadges:
  • SQL Cursor to use or not to use

    Hi, I've been told to never use cursor in SQL, because of possibility of memory leak, etc. But I have no idea of how to implement my script without them. My script doesn't execute anything on the database, it simply use cursor to create another TSQL script that does the execution. EG. open cursor...

    Db23290 pointsBadges:
  • Is there a query to retrieve datatypes from SQL stored procedures?

    I have used the following simple query to retrieve datatypes from SQL Server 2000 tables: select TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH from <tablename>.information_schema.columns where table_name = '<tablename>' and column_name = '<columnname>' Along these...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Importing SQL Server 2005 tables from one server to another

    My developers want to make a copy of a SQL Server 2005 database from one server to another, but due to company policy, I cannot give them the restore permission. So, as of right now, they are importing each table, one by one, from one server to other. Is there a way to import all of them at once?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 or SQL Server 2008

    I hav been trying to learn sql 2005 from lyk a month or two and i think i have done a good job. Now i was about to try some security stuff in it but i saw that sql 2008 is in market. Can any body suggest me that what is the difference between the two and can I swich to sql 2008? what ever i learned...

    JrSoftwareDeveloper5 pointsBadges:
  • Database connectivity using ActiveX control

    Provide a sample code to how by using VB 6.0 connectivity can be done by ActiveX(ADO) Control tool with the database SQL Server 2000

    Reena10 pointsBadges:
  • Database connectivity using Data Control

    Provide a sample code to how by using VB 6.0 connectivity can be done by Daat Control tool with the database SQL Server 2000

    Reena10 pointsBadges:
  • Correct Isolation level for SQL2005 Subscriber.

    Hello, I'm specifying a SQL 2005 Enterprise back-end to an OLTP application which has one main DB (200GB, could grow to 600GB), a subset of which will be replicated to a separate subscriber for running read-only queries. Here's the spec, any comments appreciated, especially around the use of read...

    SuperCoolMoss140 pointsBadges:
  • SQL Server 2008 SISS error row handling

    Struggling with SISS I have data source and data destination With some bad data, I can't figure out how to set up sending the bad row to another destination There are over 50 columns. Sorce is a tab delimited text file Desitnation is SQL Table

    Mambo5 pointsBadges:
  • Spoolersp.exe Error occuring frequrently in Windows 2003 environment running a VB application.

    We are running a VB Application in Windows 2003 environment. The database Server is SQL 2005. The Application runs in a separate server and the database in another. Remote Users connect to the application through the Remote Desktop facility. Users can go for direct print as well as save to PDF and...

    Ravikswamy35 pointsBadges:
  • Migrating SQL Server 2005 back to SQL Server 2000

    How would I go about migrating SQL Server 2005 back to SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Deploying SQL Server Express to host databases off a mapped drive

    I am trying to deploy SQL Server Express to be able to host a database off a mapped drive. In an open lab environment, I can get it to open and run a database off a mapped shared drive on a Windows 2003 server. However, when I take it to a client and their area is considerably less open, I can’t...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Convert SAS to Stored Procedure

    How do I convert a SAS job into a Stored Procedure to run on MS SQL Server 2005?

    VelameLaCosa110 pointsBadges:
  • Restoring a database after migrating from SQL Server 7 to SQL Server 2005

    I am trying to migrate from SQL Server 7 to SQL Server 2005, but when I try to restore the database I get this error: "Processed 120424 pages for database 'COAST', file 'Coast_Data' on file 1. Processed 1 pages for database 'COAST', file 'Coast_Log' on file 1. Converting database 'coast' from...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Insert Data into AS400

    I am trying to insert 'int' (integer) datatype into a AS400 table. The fields on the AS400 are of type 'S' (numeric). I have tried to cast the data as numeric but I get an error. Can anyone help? INSERT INTO ebbillhp (BHNROV, BHCRTDT, BHBILLHWEB, BHUSERID) VALUES (convert(numeric,@Site),...

    Jtaylor755 pointsBadges:
  • Indexes and abstracts in SQL Server

    In regards to a SQL Server, what is an index? Also, what is an abstract, and could you please explain the types of both of these items?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Explaining a SQL query

    I have a query for finding the fith lowest salary in a SQL database, and I am not able to understand how this query will be processed internally. It is: select * from emp a where 5= (select count(distinct sal) from emp where a.sal>=b.sal) Can you explain this to me?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Calling an Oracle stored procedure in SQL Server

    I need to call an Oracle stored procedure from SQL Server. The stored procedure is written in ANSI SQL. ORCL is my linked server. I am calling ORCL.USER.PROCEDURE P1, P2, P3 and I am getting this error: Could not execute procedure 'PROCEDURE_NAME' on remote server 'ORCL'. [OLE/DB provider...

    SQL Server Ask the Experts2,585 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following