• Viewing created stored procedures in SQL Server

    How can I view stored procedures that have already been created in SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Catching blocks using a stored procedure in SQL

    I have a stored procedure in SQL that I use to catch blocks. This stored procedure is executed by a stored procedure higher up. How do I relay the error info, if there is error info, to the parent? Do I need to use a return code or is the error info just passed back, no matter what?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Migrating shell scripts

    We have to move more than 250 shell scripts from a unix to a linux environment, and also 100 sql scripts. Could you please give me some steps or a check list to follow to migrate these from unix to linux?

    Chunter110 pointsBadges:
  • Giving login and database permissions to a group in SQL Server 2005

    I am running SQL Server 2005 Workgroup Edition on Windows Server 2003 Standard Edition. I have created a global security group called ACSSales and I would like to give login and database permissions to this particular group, rather than individual user permissions. How do I do this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Setting the ODBC in SQL Server 2005

    I use SQL Server 2000, and I am in the process of upgrading to SQL Server 2005. However, when setting the ODBC, the database option for SQL Server 2005 does not appear. Is there something I have to set first before the ODBC?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Limitations on databases per instance in SQL Server 2000 and SQL Server 2005

    Is there any limitation on the numbers of databases per instance that can run in either SQL Server 2000 or SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Move/Copy System DB’s to new server in SQL 2005

    Trying to move system DB's to brand new server (really virtualized server). Server names are different. Any suggestions would be appreciated.

    Seandon5 pointsBadges:
  • Problems replicating SQL Server 2000 table

    I'm having problems replicating a table that is full text enabled using SQL Server 2000 sp4. When I start the distribution agent I get the following error: Cannot use a CONTAINS or FREETEXT predicate on table 'dbo.proposals' because it is not full-text indexed. I have run sp_fulltext_database...

    Systems Channel ATE15 pointsBadges:
  • How to generate MDX query from cube?

    hi, i am a new devy in SSAS world. I sucessfully created a cube. I am able to browse the cube. In the browse window i drag n drop the measure and dimensions to see a expected result set. I want to know where i can see the MDX query for the result set? Thanks.

    Harsai5 pointsBadges:
  • Developer 10g

    I want to connect my forms and reports of developer 10g to other data sources. e.g. Sql Server. How can i connect to it through odbc?

    Kelp115 pointsBadges:
  • Storing archived information in SQL Server or on a SAN

    My company is storing PC files in SQL Server in an image field, and this data has to be archived. Due to our retention policy, the size of this data could grow to as much as 5 terabytes total, spread over 500,000 to 1,000,000 records. Should we store this data in SQL Server in an image field, or...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Deciding on configurations for SQL Servers

    My new server has 3 x 146GB SAS 15k 3.5" HD, which came pre-configured as RAID 5, and 2x 73GB SAS 15k 3.5" HD, which came as RAID 1. Should I leave this configuration as is or should I change it?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Replicate Stored Procedures

    Is anyone aware of a tool to automate the replication of the Strored Procedures from one iSeries to another?

    Jma180015 pointsBadges:
  • Efficient storage of survey answers

    We have a website that asks the user a set of questions. The answers are curently stored in SQL database using a table that has: PersonID QuestionID AnswerID Value So one answer to one question is stored in each record. Some questions have more than one possible answers, so all answers to a given...

    Eyoder5 pointsBadges:
  • SQL Stored Procedures

    I am trying to return a count value from an SQL Stored Procedure in order to test if the record exists or not. I am calling the procedure from java as follows. CREATE PROCEDURE RTVSQL (IN LEVL CHARACTER(1), IN SYLL CHARACTER(4), INOUT FOUND INTEGER(2)) LANGUAGE SQL SELECT COUNT(*) INTO FOUND FROM...

    Jglyons15 pointsBadges:
  • Slowdown of the SAN due to overusage of temporary tables

    We make use of temporary tables when we develop stored procedures, but they also become very slow when there is a heavy workload. We have an ISCSI SAN running RAID 10, and our database, logs and tempdb (15 GB) are on the SAN. We think the SAN is overworked; the SQL Server shows no CPU. Should we...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Migrating data from Oracle 9i Database to SQL Server 2005

    I would like to migrate the data from all used-defined tables in Oracle 9i Database to SQL Server 2005. I know of options like Linked Server, SSIS, SSMA for Oracle and BCP. Which amongst these is the best way to achieve data migration?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Application transfering

    Do you know how a system (a Veritas Cluster System to be exect) automatically transfers an application from the primary server to the standby server in the case of a failure in primary server? Does the target need to pay a license for both servers in this case?

    BKDelNY5 pointsBadges:
  • DrawBacks of SSRS

    Hi I was asked this question in an interview?Please anyone help on it... 1)What are the drawbacks of SSRS? or What are the problems faced in SSRS?

    Sriradhi25 pointsBadges:
  • SQL Server 2000 to SQL Server 2005 migration

    Hi, I am pretty new to the SQL Server DB. We are working on a project where in the db is migrated from SQL Server 2000 to SQL Server 2005. I was told that the migrated databases will consume more disk space on SQL Server 2005. Is that true? If so, what is the reason for that and how can we prevent...

    Vidukarth25 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