• Behaviour of Service Broker during clustered SQL Server failover

    Hi, I have 3 instances of SQL Server 2005 hosted on a 3-node cluster, using Polyserve clustering.  Each instance is nominally hosted on its own node in the cluster. I have configured Service Broker to route messages from INST-A (on NODE-1) to INST-C (on NODE-3), using TCP and a NetBIOS name....

    SimonNZ5 pointsBadges:
  • Open IT Forum: What do you want to see from IT Knowledge Exchange in 2012?

    We asked what your goals are for late 2011 and early 2012, but now we want to know what you hope to see from the IT Knowledge Exchange community. If there's a functionality you would like to see, or a topic you want to know more about, let us know in the discussion section! Don't be afraid to get...

    MelanieYarbrough6,345 pointsBadges:
  • Adding a field when using SQL to copy a file on iSeries

    My company is upgrading some applications and I need to copy the data from current files into the new files. In some cases the new files have additional fields. Is there a way with sql to copy the current data and at the same time add either a default value or a running sequentional value to the...

    CLK35 pointsBadges:
  • Errors in creating database in SQL Server

    While creating a database in SQL Server I got error as: an exception occured while executing a transact-sql statement or batch microsoft.sqlserver,express.connection-info create database permission denied in database master Can anyone tell me how to proceed?

    velankinipriya5 pointsBadges:
  • P2V Windows XP SP3 SQL Server 2005 Express

    Hi all, can I do P2V with Windows XP SP3 and SQL Server 2005 Express? Is that is possible and how? I mean what kind of software if its doing cold or hot?

    Fulgen5 pointsBadges:
  • Exporting vb6 data to pdf using sql select query from ms access .

    hi my name is vishal. I think i have a problem in exporting vb6 data to PDF using sql select query(join query from multiple tables). i have a form in which when user selects a GRNno from combobox and then press button with caption:Generate it should generate a PDF report regarding GRNno.Given below...

    Ametuer30 pointsBadges:
  • How can I restore a database from .mdf file?

    How can I restore a database from .mdf file? I only have .mdf backup file.

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server Replication – Error 22022

    We have setup a database in one domain that needs to be replicated to another domain. we have a Metro E connection are able to access data from both databases. We have established the same username and password within SQL and AD for both domains. We have setup a publisher on Domain A but cannot get...

    cmessinger5 pointsBadges:
  • sql not retuning column using DB2 data reader

    Strange one. I have a user that created a database file using WRKQRY. In this file is a user defined result field. Its basically a text label stating the build level 'LVL01'. After all levels are run (11 total) the file is complete. I am trying to access this data using a .NET program and a iDB2...

    ToddN200011,245 pointsBadges:
  • What are your favorite cloud security blogs?

    You told us what your favorite IT blogs are, now we want to get a little more specific. Do you have any security blogs or cloud security blogs that you go to for the latest threats and solutions?

    MelanieYarbrough6,345 pointsBadges:
  • Convert Oracle Database to SQL Server with Cascade Updates.

    I am trying to convert Oracle database to SQL Server. Ten years ago I converted this same database from Access to Oracle. The database had a lot of cascade updates in it and some are not always downward flow. Sometimes they go up. I used after update triggers with deferred foreign key constraints....

    dpmcateer5 pointsBadges:
  • Setting a username and password in SQL Server

    How do I set the username and password in SQL Server to allow connection to the database?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Need SQL 2012 alert to run when job step fails

    I have a mutli step SQL Server job that when one of the steps fail an alert needs to be sent out, however the job can't fail on this step it needs to continue. I have tried a trigger on sysjobshistory but that has gotten kind of ugly. So for example: 3 step job step 1 completes goes to step 2 step...

    tcstl95 pointsBadges:
  • complexity for shell script migration

    we have approx 700 shell script which is written for sybase ASE. and we have to make them compatible to work for SQL SERVER 2014 as we are migrating our database from SYBASE ASE 15.7 to SQL SERVER 2014. could you please tell me what should be my checklist in every shell scripts?

    mayurigupta915 pointsBadges:
  • Prompt user to change password before expiration Issue

    I have a problem with only one user so far where the system will not notify them that their password will expire in 'X' days. I have the following item set in the GPO: "Interactive logon: Prompt user to change password before expiration - 5 Days" I've checked the Group Policy results and it shows...

    Kmeister0 pointsBadges:
  • How can I pass tablename as a parameter in MySQL stored procedure?

    my SQL stored procedure is like this.... ALTER PROCEDURE [dbo].[Sp_InsertDataMaster] @_ImageID int, @_Stat bit, @_tablename nvarchar(200) AS begin declare @strTemp nvarchar(max) set @strTemp = 'Insert into ' + @_tablename + '(ImageID,Status) values ('+ convert(nvarchar(5),@_ImageID) +','+...

    Minal45 pointsBadges:
  • connect sql server with tcp/ip how can i do?

    connect sql server with tcp/ip how can i do?

    DangerM5 pointsBadges:
  • iSeries stored procedure isn’t returning value when calling RPG program

    Our team currently has a stored procedure that calls an SQLRPGLE program. It's running great as we have verified the debugger and it sends the return value as expected. But the problem is what is returned when we're looking at cmd.Parameters["@ISMATCH"].Value = {} Here's our stored procedure:...

    ITKE346,360 pointsBadges:
  • SQL Server on SAN

    I a two server set up. Server one for my application and server two a SAN for my SQL Server.  Should I install the SQL server on the SAN?  I have read about 10 articles and some state to install the SQL Server on the app server while others say on the SAN and yet others say it really does not...

    Needplease5 pointsBadges:
  • How to find paragraph by typing a word

    I have saved resume in SQL table. If i type any word in the resume. I need to get that particular resume (resume may have spaces & symbols).

    Swethakaranam5 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