• Copying a database from SQL Server 2000 to SQL Server 2005

    I am using the Copy Database Wizard to copy a database from SQL Server 2000 to SQL Server 2005. I gave it the data file path on the source server (ex. \SOURCEDBC$Program FilesMicrosoft SQL ServerMSSQLData), but it returns an error when I attempt to execute the package ("Access to the path...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Restoring SA access to SQL Server

    I have somehow removed my SA permissions from my SQL server. I do not know the SQL SA password. Is there any other way to restore my SA access to SQL? I am a local admin on this server.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Database hanged due to concurrence

    Hi to all. We have an application running under Windows 2003 Server, database SQL Server 2000, client/server, 60 users updating or consulting data. We did a concurrence test. We asked several users to search for same string at same time and the database got hanged. Will that be a configuration...

    Ome0015 pointsBadges:
  • write multiple images from SQL database using response.binarywrite

    It seems I am able to write a single image with the following code: ID1 = replace(request("ID1"), "'", "''") Dim connStr connStr = Application("DSNFPT") Dim rs Set rs = Server.CreateObject("ADODB.Recordset") rs.Open "select [Image],[ContentType] from FPT_Images where ID = " & int(ID1) & " order by...

    Tacopants5 pointsBadges:
  • error in reunnig sql plus

    when runnig sql plus of oracle 9i,after giving puser id and password protocol adapter error is there..iused both id an pw i.e. system and manager or scott/tiger

    Krshah5 pointsBadges:
  • Error messages during the creation of a mirror database on SQL Server

    I am trying to restore a database from one SQL Server to another to create a mirror database. However, when I enter “RESTORE DBMirror FROM DISK=’C:Backup DBMirror_FULL.BAK’ WITH NORECOVERY,” next to the database name appears the error message “Restoring…” It never goes away. What...

    SQL Server Ask the Experts2,585 pointsBadges:
  • xml create form sql database

    i want to create xml file from sqldatabase.i hav many record and i want dynamically create xml file.ihave a multi table taht i want in xml file

    111111222225 pointsBadges:
  • problem with sys.endpoints

    Hi, I have ms sql database created in 7.0; I had shift all the data files to a different server where ms sql 2005 is installed. I was able to start sql server from the 7.0 database by specifying the startup parameters. But when I try to connect thru sql mgmt. studio I am getting the "object not...

    Vsskmk5 pointsBadges:
  • db backup

    why does sql bu returns a time out

    Stanja10 pointsBadges:
  • SQL client number

    If I have 500 clients in an environment, does that mean I need 20 servers with SQL 2005 Enterprise--each with only 25 client availability?

    Cnotejunebug20 pointsBadges:
  • Creating Alert/Email when Automatic Failover Occurs In Sql-Server 2005

    Hello All, I want to send email alert when aotomatic failover occurs in in Sql-Server 2005. I mirrored my database using High Safety with Automatic Failover option.

    ITHULK10 pointsBadges:
  • 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:

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