• XML create form SQL database

    I want to create XML file from a SQL database. I have many records and I want dynamically create XML file. I have a multi table that I want in XML file.

    111111222225 pointsBadges:
  • Page level lock in SQL 2008

    What is the meaning of page level lock in Microsoft SQL 2008 enterprise edition? How many records are locked?

    Akansha150 pointsBadges:
  • Stored procedures in master DB, SQL Server 2005

    Does anyone know where I can get a list describing, in layman's terms, all the sp_usr... stored procedures in the Master database? New to all this and don't have the time or knowledge to decipher the TSQL behind it. Hope someone can help! Cheers!

    GillsJules5 pointsBadges:
  • SQL Server Express 2005 freezes

    I have a server machine running Windows Server 2003 and SQL Server Express 2005 for a client-server application. All clients machines access the server through a router fine with good response time but if the internet connection fails suddenly the SQL Server freeze. Any SQL command takes a long...

    Navegante21225 pointsBadges:
  • How to create a setup of Windows application

    How to create a setup of Windows application with SQL Server database file?

    sagarpawar10815 pointsBadges:
  • Remote Call issues in SQL Server 2008 R2

    I’m having problems connecting to my database remotely in SQL Server 2008 R2. I get the following error. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct...

    ITKE352,565 pointsBadges:
  • How do I retrieve data from Visual Basic 6.0 with SQL?

    How can I retrieve data in VB 6.0 from SQL?

    Escabarte5 pointsBadges:
  • SQL code -727

    Does anyone know what -727 SQL return code is?

    Bebiii15 pointsBadges:
  • Matching key question in SQL Server

    Hi, Here is the problem I am trying to solve. I need to extract some information from a table, say Tab2, using a matching key from another table, say Tab1. Tab1 has two columns, Col1 and Col2. Col1 is digits (1, 2, 3...) Col2 has letters (AA, Aa, aA, aa, AB etc) I need to use Col2 to join to Tab2...

    Slowlearner25 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:
  • Re-linking SQL Server database user

    Hi Guys, What I am trying to do is relink a database user to a new domain user, and also keeping the same database user name. I am able to do this when I run the following command, and if the database user isn't the same as the login name. use temp alter user TestUser2 with name= TestUser2, login=...

    Db23290 pointsBadges:
  • Retrieving and adding data to tables on different SQL Servers

    Is it possible to retrieve data from two tables, located in two different SQL Servers in one domain, and then add the data and save the result in another table in a third SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Utility to Compare Security Configuration Between SQL Server 2005 Database

    We are trying to restore a SQL Server 2005 database from a production to a QA environment. We are using certificate security, multiple schemas and certificate signed stored procedures. We need to find a utility which can tell us security configuration differences between the two environments. Any...

    Aiguy5 pointsBadges:
  • When submitting a procedure via CL program, I do not get any abnormal end message.

    When submitting a procedure via CL program, I do not get any abnormal end message even though the procedure has not not completed normally, is there anyway by which we can find the cause of the failure of the completion of the procedure normally.

    JohnsonMumbai1,160 pointsBadges:
  • SQL Express used for SSIS?

    Can SQL Express be used for SSIS?

    Lianv10 pointsBadges:
  • SSRS interview questions and answers

    I'm looking for SSRS interview questions and answers. Can someone point me in the right direction?

    LouTermini5 pointsBadges:
  • Restore from .Bak file issue in SQL Server 2000

    First off thanks for reading, I am new to SQL (SQL Server 2000). Unfortunately I just had the array my Data was on and my tape backup get toasted, I was able to do some data recovery on the remaining drives and pull off about 15 different .bak files for the database I need to restore....

    selli285 pointsBadges:
  • T-SQL stored procedure conversion to C# CLR assembly

    I'm wondering why it is difficult to find an example (in literature or Internet) example of converting a T-SQL procedure which contains "out" variables into identical C# CLR stored procedure. Is there something which prohibits this conversion? If not, can someone provide or cite example? Real...

    Tann5 pointsBadges:
  • What wiki software do you recommend?

    Just as the title suggests, what wiki software (DokuWiki, MediaWiki, etc...) do you suggest to run?  The purpose of this is nothing more than to make a remote note-taking sort of scenario, so it's not something for anyone but me to be used.  I know I could do my own thing and stuff, but I'd...

    Eric Hansen2,065 pointsBadges:
  • SQL Report Help

    Hi I'm dave and I'm new to the forum, SQL and SSRS. Thanks in advance for your assistance and patience. I have a recall report that produces letters for every patient who needs to return to the office on a certain date based on their recall plan (a plan that determines when they should return based...

    Blowinup5 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