• how to get list of encrypted objets in sqlserver 2005?

    i need a list of encrypted store procedure name,encrypted trigger ,encrypted functions from sql server 2005.

    Subrata735 pointsBadges:
  • Home Network Configuration SQL Express 2005

    Hello, I am pretty new to Sql. I had setup a SQL Express 2005 Advanced on a computer w/ xp on it before and had no problems. I recently purchased a installed a new computer (the other one died) w/ Windows Vista. As before, I downloaded and configured Sql Express per instructions for the software...

    Ddog06295 pointsBadges:
  • Scheduling a DTS Package

    Hi On MS Windows Server 2003 I have a DTS Package in SQL Server Enterprise Manager. The DTS package runs fine in SQL Server Enterprise Manager. How do I add that DTS package as a scheduled task? Thanks P

    Pmwhelan5 pointsBadges:
  • How to install a passive node on an active/active SQL Server cluster

    We have a SQL cluster server running with SQL Server 2005 Enterprise Edition SP2 on Windows 2003 Enterprise Edition. Currently the cluster has 2 nodes with Active/Active. Now I need to add a new node as a Passive node. So once I’m done, the cluster will be a Active/Active/Passive cluster. Because...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Connecting Crystal Repor2008 to SQL 2005 database

    Via Crystal Report2008 I have to produce a number of reports collecting data from a SQL2005 database running on another computer(2). This computer is not in my domain, but in a workgroup. However, the computer has the same IPaddress category. Anybody can help me with the steps to connect to the SQL...

    Antillas15 pointsBadges:
  • schedule a restore plan

    using sql 2005, management studio,, how to schedule a daily database and restore plan.

    DRE125 pointsBadges:
  • Data Migration Betrieve Tables to MS SQL Server 2005

    Hi! could somebody help us advice on what to do and what to prepare if we are going to migration our current database Betrieve tables to MS SQL Server 2005? Thanks. Note: We are currently accessing the Betrieve tables thru PervasiveSQL v8 engine.

    Wonderer0820 pointsBadges:
  • Moving a SQL database from one host to another

    I need to help out in a move of a site coded in ASP/VBScript from one host we're having major problems with to another host that has been highly reliable for us. They both offer all the same features needed for this site, but we don't know how to move the SQL database along with the site. Can...

    Kwoodall10 pointsBadges:
  • How to Schedule jobs in DTS in sql server 2000

    I have got 7 jobs in my sql server server agent, now i want them to run simultaniously one afer the other using DTS, is it possible,if yes how can i do it

    SRI HARSHA10 pointsBadges:
  • Query error when using application role with ADO connection

    I am developing an application with an ADO connection. I need to run a query on two different databases on the same server using an application role. When I run the query I get an error \domainusername does not have a logon on database (referring to the second database). Is there any way around it?...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Backup SQL database with BRMS AS400

    Running BRMS on i520 v5r4 LTO 4 tape library. Company just installed on seperate machines, same network: Windows2003 Server with MSSQL Database. I want to use BRMS and our robust LTO library system to get to the data on the SQL Database. Have little success with the LTO 4 being supported by...

    Vic58535 pointsBadges:
  • Error when upgrading SQL Server 2000 to SQL Server 2005

    I am upgrading SQL Server from 2000 to 2005. While upgrading I have received the below mentioned error. Kindly review and advise me on this. By the way, I have sufficient disk space on my server. "TITLE: Microsoft SQL Server 2005 Setup SQL Server Setup has encountered the following problem:...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Is there a way to set up database mirroring in SQL Server 2005 to receive failover notification?

    I'm setting up database mirroring in SQL Server 2005 Standard Edition and was wondering if there is a way for SQL Server to send me a notification of a failover and for it to automatically run a script when the mirror is brought online.

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server error message ‘Could not find the index entry for RID ’1628000000a412030044160000869a0000040000′ in the database

    I'm getting the error 'Could not find the index entry for RID '1628000000a412030044160000869a0000040000' in the database. The table is a very big table and lots of transactions are happening every minute. Please let me know what would be the possible cause and solution for this problem.

    SQL Server Ask the Experts2,585 pointsBadges:
  • How do my database sql2005 database to another server with management studio

    Has sql 2005, using management studio to do a full backup of my database. Using maintenance wizard to set the backup. I only see my local drive and not my share folder created onthe other server where i want to place the .bak file. Any idea will be helpfull.

    DRE125 pointsBadges:
  • datetime conversion

    SQL Analyzer has issues w/below relative to the datetime conversion- - what is the problem? convert(varchar(10),ft.postdate,101) 'PostDate',

    Mictip5 pointsBadges:
  • DB size

    Hi, I am using a software which is using SQL DB. Each time there is an error (one of the tasks fails) the DB grows. I would say over 1G per day! Currently I have DBs which are 45G and I am running out of space. Anyone has any idea how to shrink the DBs or do something to reduce the size. The LDFs...

    Ellie145 pointsBadges:
  • update query fails as table gets locked by select query (sql blocking issue).

    I have a perl script which updates some table records in sqlserver 2000, the flow is like below: * A select query This select query selects IDs(with other records too) * An update query This update query updates a bit column from 0 to 1 for the IDs retrieved from above select query. The problem I...

    Shashanksingh1915 pointsBadges:
  • Can’t Install SQL Server 2000 on Window XP SP2

    I try to install SQL Server 2000 on Window XP SP2, but there is an error message mean "OS not support.". What should I do? How can I install SQL Server 2000 on Window XP SP2? Please, give me the best and detail answer. Thanks.

    Yoyo5 pointsBadges:
  • Mobile phone notifications

    Hi How to setup mobile notifications on jobs using SQL Server 2000. Aim is when a job fails I should receive SMS notification on my mobile phone. Please show me web sites on this topic. Please help. Thanks & Regards -Rajesh.

    Krajdba10 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