• SQL to insert comma-delimited string value to table column

    I have string like '1,2,3,45,6,7,8' I want to insert each comma separated value in a table column...my output look like this: COLUMN 1 2 3 45 6 7 8

    231219835 pointsBadges:
  • what is different from MSSQL, MYSQL and Oracle 11g?

    what is different from MSSQL, MYSQL and Oracle 11g? Which one is the best for 15000 transaction daily?

    Juna060615 pointsBadges:
  • Grant users rights to run reports on reporting services

    How do I grant users rights to run reports on reporting services?  Those with admin access can run them, but users without admin access can't - they get an error that they don't have access to the data source.  When setting up the source, we used windows authentication.  I've given clearance on...

    Cindyfiller45 pointsBadges:
  • Restoring Database

    I accidentally deleted contents of a table and is now trying to recover the deleted rows.  I do not have a backup (how stupid of me).  I do have a .mdf file, however I believe i copied that file while SQL Server 2005 was running.  Is there anyway to recover this deleted data?

    Tyecom5 pointsBadges:
  • Find a particular text from all tables in DB.

    Hi There are 100 tables in my DB. I want to find if a text say "ABCD" is availbale in any these 100 tables. If it is availbale can we list those tables. Can someone help me out with the Query.   Regards Mayur

    Mayurkhe295 pointsBadges:
  • Where did the undocumented stored procedures go in SQL Server 2008 Managment Studio?

    Is there a way to see the undocumented stored procedures in SQL Server 2008?  They don't seem to show up in the explorer tree in Management Studio the way they did in SQL Server 2000's Enterprise Manager. I was able to run XP_FIXEDDRIVES but it doesn't show up in the list under stored procs in the...

    Brenbart5 pointsBadges:
  • How to pass a store procedure and a variable to a datagrid

    I am a newbie when it comes to passing parameters to a control. I am programing in VS 2008 using VB as the language. The grid is in an ASP.Net (3.5) page  I have set up a store proceduer in SQL Server 2005 as follows: CREATE PROCEDURE   usp_selEmpSSN--Transfer all records from tbl_CL with the...

    Neilo125 pointsBadges:
  • SQL Server 2005 error log, could not read information for this log entry

    Hi, There is a SQL Server error log entry in the SQL Server 2005 production box with the following.   "Log Viewer could not read information for this log entry. Cause: Data is Null. This method or property cannot be called on Null values.. Content:"   Has anyone seen anything similar? Does anyone...

    Db23290 pointsBadges:
  • Create Excel file on web server by using SQL

    How can I create an excel sheet on web server by using a stored procedure in SQL Server 2005. I'm retriving data from sql select query and creating Excel file dynamically on we server of that data using asp.net. But I want to do this with the help of SQL stored prcedure. i.e. In a stored procedure...

    SwapnilD25 pointsBadges:
  • Reporting Services 2005

    Hello, I am running reporting services 2005. I created a subscrition for a report named "paid_claims" that will auto generate an excel file into a shared folder on the network. The "paid_claims" report has a link to another report named "sub_paid_claims" in the same folder. We recently renamed our...

    Rick Martinez585 pointsBadges:
  • RPGLE external stored procedure when called with OUT parameter having issues when called from C#

    We have created some stored external procedure with paramter type OUT but these were giving memory protection at C# side.However when we call it from operation navigator ,it is running succesfully.I created some SQL stored procedure with OUT paramteres and these were working correctly when invoked...

    Arush5 pointsBadges:
  • View t-sql SPID is executing

    Is there a table that I can query to view what sql statements a spid is running? I do not want to use the dbcc inputbuffer.

    Rick Martinez585 pointsBadges:
  • Create A Fixed Text File From SQL DB Table

    Hello programmers. After doing much research I am unable to resolve how or where to custom format each field of my SQL table output into my text file. Can someone help me with enhancing the below vb script? I need to reformat certain values. Do I do the formatting in the Dim section or in the if...

    Ilfoprog50 pointsBadges:
  • SQL saving off data created to copy into new database

    Data is created in one SQL DB for testing and then a new DB is created. Is there a way to save the data you need for testing in the new DB, so you don't have to create it each and everytime for testing?? Any suggestions would bew appreciated.  Thanks...

    Flyershockey25 pointsBadges:
  • Writing a stored procedure across two databases

    I currently backup our live databases and restore them into a QA environment. This doesn't cause a problem with our stored procedures as they have all been written without hard-coded database names.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Security Update for SQL Server 2005 Service Pack 3 (KB970892)

    hi! each time i try to update the captioned update it fails. i guess it has also caused my ooutlook to crash!!! pls help

    Teamwork085 pointsBadges:
  • passing data between two SQL Server databases

    I am having an issue to passing data between two SQL Server databases.  I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 200 related tables.  Also we are not allowed to use the...

    LL12325 pointsBadges:
  • Microsoft servers software and hardware upgrade

    We have the following architecture: 2 Microsoft SQL servers. OS is windows 2000. SQL database  is 7.0. The server hardware is HP proliant 800. The server is a SQL applicaiton server. The server is used for data mining. RIght now it has a script that used bulk inserts to push "csv" files to the...

    Techzon1225 pointsBadges:
  • Access Rights in SQL Server 2005

    Hi,  I'm using sql server 2005 and in my application i have 2 DB say A and B , and 2 servers SR1,SR2 and DB A,B and present on both (SR1,SR2).now i want to give access to users entering my DB not to view any of the entries made in the DB, not even the Tables created in my DB...pls provide me Step...

    ENGG66615 pointsBadges:
  • bcp – clock time meaning

    Attempting to BCP a large resultset using a view and the queryout option. I have been playing with the network packet size and the size of the batche using join conditions. When looking at the command line output file. What do the values in "Clock Time (ms.) Total" signify. I am trying to measure...

    Joetig35 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