• How to generate a column name in a table dynamically

    hi, I have to generate dynamic columns for a temp table. I have a temp table with column a, the column b should be generated based on a condition. B conditions are if value> 10 i have to genrate the column as 10 and if the value >20 the column name should be 20 etc....n values.... If i select...

    GIG240 pointsBadges:
  • A job to move database files from one server to different server

    Hi I have job which creates databases based on month in analysis services which contains cubes in the databases. I need to create a job to move the database ldf and mdf files of the previous months removing the database from the server if the month changes to next month. The database files should...

    GIG240 pointsBadges:
  • Tuning a simple SQL statement in SQL Server 2005

    How would I tune a simple SQL statement, like "SELECT @eno = eno FROM emp WHERE dno = @dno," in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Running a performance baseline trace on a SQL server

    When you are running a performance baseline trace on a SQL server, how long do you typically run the trace? Or, do you run multiple traces at various times of the day?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Is there a way to make ODBC see SQL Server 2005 Synonyms

    I have created synonyms on tables in SQL Server 2005. Does anyone know of a way to make those synonyms available through ODBC for use in MS Access? I have installed the latest SQL Server Native Client development pack; but the synonyms do not show up in the list of tables when linking via ODBC.

    Randym1,740 pointsBadges:
  • SQL programming

    If I have info about clients on my server is it possible to program SQL to send only certain parts to certain people who all require different information to save me typing it in manually every time. Much like a price comparison website. Also is it possible to access my database from outside the...

    Katy20 pointsBadges:
  • SQL Server 2000 connection to multiple databases using variables

    I have a fairly simple select statement that joins three tables from two SQL Server 2000 databases. It works fine, but now I need to run the stored procedure against different servers, so my hardcoded reference to the second database (currently coded as "secondDB.tableName.columnName") needs to be...

    CO Bill120 pointsBadges:
  • Is it possible to copy system DBs to another server?

    Hi, I am at total lost at trying to copy system db(master, model, distribution, etc) from a 2005 server on one machine to another 2005 server on a different machine, so all the logins, job, etc are also copied to the new server. I have tried to google this problem and am at a lost to how to do...

    Db23290 pointsBadges:
  • Creating XML file using SQL Server 2005

    How to create a xml file using sql server 2005? what are all the steps to do for this?

    Sunithashree5 pointsBadges:
  • MIgration to 64-bit Sql Server

    What issues do I face with database file compatibility if I migrate from 32-bit SQL Server 2000 to 64-bit SQL Server 2005?

    Tomfitzrugger5 pointsBadges:
  • Deleting a SQL Server with a common name

    How can we delete a SQL Server named "instance" when more than one item named "instance" is present?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Implementing indexed views on a SQL Server

    How can I implement indexed views on our SQL Server? Is there an example that shows how they would improve query performance?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Producing a nightly tab delineated file for a SQL Server database

    I wish to produce a nightly tab delineated file, based on a recordset, for our SQL Server database. How could I program this to be produced at a specific time each night?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Analyzing Existing Indexes

    Hello, I am trying to analyze existing indexes on few tables. I think I can do this by using system views like sys.db_dm_index_usagestats, physicalstats and operationalstats. I am here trying to figure out disk space used by each index, I/O stats ,fragmentation etc I am wondering if ,Apart these...

    Sqloholic25 pointsBadges:
  • Improving the performance of full-text searches in SQL Server 2005

    Why does a full-text search perform so slowly in SQL Server 2005? How can i improve the performance, in general, of query results ?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2000 (Performance Trace)

    Hi All, I have a job which is running since last 6 months. The job was taking around 2-3 hrs to be completed. However, for the last couple of weeks, its taking more than required time (Max-26 hours)and we have to kill the job for users to acces the database. I am not able to find any clue to it. I...

    Bakash0 pointsBadges:
  • LSXODBC and MS-SQL Stored Procedure Parameters

    Using LSXODBC and ODBCResultSet, how do you pass parameters to a stored procedure using result.Execute or result.ExecProcedure? I am looking for a working example not just syntax.

    Mzrn1x5 pointsBadges:
  • Using answer as criteria in sql server

    I have a table that has a demand order and a supply order I want to search for a order in the demand order column it may have more than one supply order and then I want it to look to see if that/those supply order is in the demand column and if it is get the supply orders and so on. So essentially...

    Jeremyj545 pointsBadges:
  • Accessing an SQL 2005 Synonym with ODBC

    Is there a way to link to a synonym in SQL 2005 using ODBC and MS Access?

    Randym1,740 pointsBadges:
  • SQL 2005 and Security Account Delegation

    I read this feature for SQL2000 SP3 but I wonder if this is still valid for SQL2005 or, if it has changed which is the new feature that enables to retain the authentication credentials of the original client.

    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