• I want to create backup of SQL database and set a password.

    HEllo All  i want to create backup of SQL database and want to set Password that anyone who restore this backup after that it cant be able to restore database without knowing perticular Password .... is this Possible....? if Yes please tell me How...? Thanking You Raviraj

    Raviraj1235 pointsBadges:
  • Subfile sort

    I have a subfile program for updating, creating, and displaying item information the user can select from to create, view or update detail. The subfile shows item number, description, etc from my main file (i'll call itemnum1)and a vendor item number from an auxiliary file (itemnum2). My question...

    filuphaze475 pointsBadges:
  • How to install SQL 2005

    Hey what was minimum hardware requried for SQL2005

    Roony5 pointsBadges:
  • Slow response with SQL server over a network.

    Hi, We do a simple select 1 million record over a client server setup with SQL server 2008 and it take 10 times more time to get the results that doing the same request with Microsoft access db. Exactly the same setup for the network. Any special setup in SQL server we are missing. thank you for...

    Jack26015 pointsBadges:
  • Stored procedures to script table data in SQL Server 2005

    Are there any stored procedures or command line utilities that I can use to script out the data from a particular table in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Recovering lost data from SQL Server 2005

    Running SQL Server 2005. I found that I had lost about 2000 records the Assets table and more records in the associated tables Timeassets and AssetBillingrates.  Each of the tables uses an Id field as the Primary Key. I was able to identify the key records that had been lost and tried inserting...

    BClawson10 pointsBadges:
  • How to move sql server clustered instance to a separate stand alone server

    We are in the process of moving our Production instance and databases. Would be of nice help if anyone could shed their thoughts on How to move sql server clustered instance to a seperate stand alone server (along with system and user databases). We are stopping the cluster, moving the drives to a...

    Sqlserver2008r25 pointsBadges:
  • Crystal database expert not showing views for database

    When I open database expert and open a new DB connection, only tables and stored procedures are shown. How do I get views to show? I can see views for other databases except this one.

    denise7525 pointsBadges:
  • How to handle record lock using embedded SQL?

    I am using SQLRPGLE program,need to handle record lock in sql statement ..plz suggest?

    Samule400160 pointsBadges:
  • CPF5032 and SQL RPG

    How do I unlock the data file to avoid halt ? CL used to sort file and call an RPG that cleared a field (followed by further processing). When I switch to an SQLRPG to clear the field, I get CPF5032 in the next program. Yes, I tried the UNLOCK op code in the SQLRPG but same result. No halt using...

    aceofdelts1,880 pointsBadges:
  • Interview

    I have an interview on SCADA systems. Could anyone help with what kind of questions should i be expecting, they need someone with knowledge in everything right from communications,controls and database. (HArdware + Software).I dont have much experience on my resume but still they considered me for...

    Controls0 pointsBadges:
  • Strange Oracle 9i behaviour

    We are seeing some very strange behaviour in the performance of a query on our database. We have run the same query on the actual database server (s1) using sql+, and on a server (s2) 1 hop away (taking out network performance). The exact same queries, without any bind variables, are kicked off...

    Darryn765 pointsBadges:
  • Networking solution

    I have a senario of SMB requiring a win2008 server, Apache web server, Sql database server, Exchange 2010. How many servers do I realistically have to get. 24 hosts with view to expand. And future interstate branches. Voip is a consideration also. VPN........ The site is 2 floors. No...

    Jasonjlewis45 pointsBadges:
  • Earning badges pays off – TODAY!

    We recently announced that the IT Knowledge Exchange Badge Program is beginning its reward phase, meaning that you can earn great prizes just for doing what you've already been doing in the community! Initially we planned to send out a first-time prize for everyone who has been active in the past...

    MelanieYarbrough6,345 pointsBadges:
  • Create linked server from sql 2000 to sql 2005

    Does anyone knows how to create a linked server in Sql 2000 regarding a database to Sql 2005. All I want to do is a selection from a table in sql 2005 and insert into a table in Sql 2000   Thanks in Advance

    ManosZim30 pointsBadges:
  • Reading a file in Reverse Order in CL Program

    ) In CL program how can we read a data base file in reverse order.

    Chraghuveer25 pointsBadges:
  • SQL Server 2008 Insert Into vs Insert Statement Recompile

    I have a stored procedure that executes a t-sql statement using sp_executesql. This t-sql code recompiles everytime it runs using "INSERT INTO" but when I use "INSERT" only it will not recompile. What is going on here? sample: create table #test (id int) Recompile: insert into #test select id from...

    Rick Martinez585 pointsBadges:
  • Declaring the same file twice with two OPENID and reading the same file twice in CL Program

     Is it posssible read a db file while declaring twice with openID     and reading the same file twice

    Chraghuveer25 pointsBadges:
  • Trigger or Stored for lock and unlock database for 15 minute

    Dear Sir, I create a login form in which if you insert password 3 times wrong then u r account is locked for next 15 minute. and we send a random password  on referenced emailid which is sent after 15 minute. For these 15 minute the account isactive='false'. So can u please help me to give code...

    Programmer0075 pointsBadges:
  • Can two separate cursors update the same SQL table when executed together?

    I have three tables. Table One is a master table which contains rows which need to be updated with data from the other two tables (I'll call them Table Two and Table Three). I have created a cursor which updates existing rows in Table One with data from Table Two. This works fine, and following the...

    MrRussellWebb5 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