• Moving SQL 2005 databases with no downtime between servers

    We have 2 SQL 2005 servers and would like to move the database and the logins and passwords from server to server. I ran backup and restored the full database with no recovery mode which allow me to copy the transaction logs then I transfered the logons and ran sp_change_users_login to associate a...

    Theitman25 pointsBadges:
  • Linking to a table in SQL with Visual Basic

    How could I link to a table in SQL using Visual Basic?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Retrieve images from SQL database using VB.NET

    How do I store and retrieve images in SQL Server using VB.NET?

    AnandKanade5 pointsBadges:
  • Sponsor Post: VMware Expert Live Chat – Tuesday 10/26 at 11am EDT

    Join us on October 26 from 11am-2pm EDT for Virtualizing Business-Critical Applications. In this LIVE chat with VMware experts, you’ll learn about application performance considerations, best practices and use cases for deploying Tier 1 applications on VMware. Click here for reminder email to...

    EmNichs3,250 pointsBadges:
  • Parameter in select statement

    Hi, I need to pass a parameter into a stored procedure which values are dynamic always. Executing a variable which having the Select statement. Following query working fine. BEGIN DECLARE @strQuery NVARCHAR(MAX) DECLARE @CountryId INT DECLARE @CityId INT SET @CountryId = 2 SET @CityId = ' AND...

    Plugsharma40 pointsBadges:
  • I am unable to find “Create Partition wizard” in SQL Server 2014

    I want create Partition on one table, I have SQL Server 2014. Where can I find "Create Partition wizard". I have done same in 2012, under table option "Storage->Create Partition"

    VikramD5 pointsBadges:
  • Search Data in SQL Server database

    What can I do to prevent from the data that doesn't have in database in SQL Server alert message? Don't I have to use connection a VB.NET to SQL Server from use textbox to search?

    dara925 pointsBadges:
  • Converting an Excel 2013 file to a flat file in notepad for SQL Server 2008 R2 export/Import Wizard

    I am a student. I have to convert an Excel 2013 spreadsheet with 7 tabs of different table information. I have to then import it from my host computer into SQL Server 2008 R2 which is located on my virtual machine. Please help me and if you need more information, then let me know. Thanks in advance!

    Ronnibelle5 pointsBadges:
  • 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:
  • SQLRPGLE – How to override data set data structure at run time

    I currently have an SQLRPGLE routine that receives a SELECT statement as a parameter and then fetches the data set into a data structure based on the file. This only works over a single file as the datastructure is created at compile time and has to be based on filea. I would like to make this...

    NarkedDiver20 pointsBadges:
  • How can I make backup 4 file only and restore in SQL Server 2000

    How can I make backup 4 file only and restore in SQL Server 2000?

    01058478505 pointsBadges:
  • SQL – Pass the result of the first query as the second query select column name

    I want to pass the result of a SQL query as the column name in another query eg. (note there will be a single result for the first query): SELECT CASE WHEN fld_type1 = 'A' THEN 'VAL_ALPHA1' WHEN fld_type1 = 'D' THEN 'VAL_DATE1' ELSE 'VAL_NUM1' END AS FIELDNAME FROM TABLE1 I want the result of the...

    Chris12325 pointsBadges:
  • Website and SQL database connection

    Can anybody tell me how to connect the MS SQL database with the JSP pages. I got the IP address and username with the password. I know how to connect it in a local system but I don't know how to connect it with the database in the web server. Please help me to solve this matter.

    Advancedjava25 pointsBadges:
  • Limiting SQL injection in SQL Server 2005

    I have a site in ASP and on the back-end in SQL Server 2005, but I keep finding SQL injection on my site. Is there code that will prevent SQL injection from getting onto my site?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Image capture and store into Sql Server 2005 code in vb 6

    how to store image in Sql Server 2005 by using visual basic 6

    nishantganapa0 pointsBadges:
  • I am using SQL Server 2005 and the following error keeps being reported in the Domain Controller Logs:”There are multiple accounts with name MSSQLSvc/…..”

    I am using SQL Server 2005 and the following error keeps being reported in the Domain Controller Logs: "There are multiple accounts with name MSSQLSvc/....."

    Tizi30 pointsBadges:
  • The specified module could not be found

    We are trying to install a software (on about 70 workstations) that uses a SQL type database that is stored on our server. We all have Windows XP and our server is Windows Server 2003. About half the Workstations are able to connect to the database with no problems. The rest are unable to connect...

    Kc54555 pointsBadges:
  • SQL Server datetime

    Hi - When I run this: select cast ('461129' as datetime). I get 2046-11-29 00:00:00.000 instead of 1946-11-29 00:00:00.000 Can you please let me know why and what I need to do in order to get the required results? Thanks.

    DBM10 pointsBadges:
  • ASP.NET

    I have four textboxes and a database which is already created. What I want to do is if i enter the value in the four textboxes and press button, it should automatically gets updated or saved in the database.

    5555544425 pointsBadges:
  • SQL2000 linked to SQL2005 doesn’t allow TRAN selects

    Hi all, I have a SQL2000 machine that has a linked server that runs SQL2005 (before this was a SQL2000) When the systems were both SQL2000 from ServerA it was possible to run: BEGIN TRAN SELECT * FROM MYSVR.MYBD.DBO.MYTABLE COMMIT TRAN After the ServerB has been upgraded to SQl2005 the code above...

    alessandro.panzetta9,725 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