• Migrate User & Permissions SQL 2000 to SQL XXXX

    Hello, I need to a new windows server, but too install MS SQL Server 2005. Who know or have a code to do this job. Tank you so much.

    Njimenez5 pointsBadges:
  • Failover issues in a SQL Server 2005 mirrored database

    I have a SQL Server 2005 mirrored database with a witness. Everything seems to be working OK but I am having problems in the instance a failover occurs. Once the primary server goes down, my access to the database continues normally once both servers are back up and running and the old mirror is...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Transaction Log – SQL Server 2005

    How do i find out what transaction log file was last applied to a database?

    0 pointsBadges:
  • SQL script to disable views after a demo period.

    Hi, I have a sql view that I created for someone on a test basis. I want to create something (stored procedure, trigger, etc) that will delete or disable this view after a 30 day trial period. I prefer to make the view unvisible even to the "sa" administrator so that the view can not be recreated...

    Katiekat5 pointsBadges:
  • Retrieving System information

    I need to retrieve logins and users for all databases by server for SS2000 - 08. Querying the system tables sysservers, sysdatabases, sysloginns and sysusers provide the information. But how do I collect all that information with one query hopefully that I can run against all serves in the...

    Calcindor5 pointsBadges:
  • Are there any specific considerations we should be aware of as we attempt to migrate applications to a Hyper-V virtualized machines?

    We have major applications (Exchange 2007 and SQL 2005) that we have in a mission critical configurations “clustered.” Are there any specific considerations we should be aware of as we attempt to migrate these applications to a Hyper-V virtualized machines? Are there any resources available...

    ITKE346,360 pointsBadges:
  • FirstIAM page of a table in SQL Server 2005

    Hi, Can you please explain how is the "FirstIAM page of a table" is calculated in the sysindex view, in SQL server 2005. Is is stored in some system table or is it calculated every time a table is accessed? Pardon me if this sounds to be a stupid question.I am new to SQL server 2005 :-)

    JudeAj5 pointsBadges:
  • Moving .MDF files from SQL Server 2000 to 2005

    Is it possible to just copy and paste .MDF files from SQL Server 2000 to 2005 instead of going through the whole migration process? My company doesn’t have the time that a full migration requires, so we are thinking about just keeping the files and pasting them once we have SQL Server 2005...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 -I want duration from the condition below- without cursor would be preferred

    I have the following table: CREATE TABLE [dbo].[DurationCalc]( [Id] [int] IDENTITY(1,1) NOT NULL, [ContractId] [nchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Status] [nchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ModDate] [smalldatetime] NULL ) ON [PRIMARY] And the following are the...

    SqlX15 pointsBadges:
  • connetion failed ,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL

    I enabled remote connections in sql server 2005 configuration and services but also it giving same plz help iam trying this from three days

    Shaz255 pointsBadges:
  • SQL 2000 Upgrade

    I am upgrading four sql servers 2000 to 2005. If i do an inplace upgrade to the default instance would i need to change any passwords for linked servers, services or sql accounts?

    0 pointsBadges:
  • Running a lengthy query on SQL Server 2005

    We are running SQL Server 2005 and Windows 2003 Server. I ran a query in SQL on a PC with one dual code processor and 4GB and it took six hours. However, we ran the same query in SQL on a brand-new server that has 4 quad core processors and 32GB of RAM, and it took 12 hours. Why would this be?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Crystal Reports in Web application with SQL Server 2005 Express

    i want to create crystal report in asp.net 2.0 web application with sql server 2005 express edition. now the name of my database which i have created its name is Database.mdf. now whenever i expert database i can find my server name but in the dropdownlist of database i can`t find my database name....

    Softdeveloper10 pointsBadges:
  • Fulltext Search – SQL Server 2005 SP2

    I am new to the SQL Server 2005 Fulltext search technology and I have not tried it yet myself. I would like to ask about availability of a feature which is provided for example by the Oracle Text technology which is indexing documents using FTP protocol. I have various formats of text documents...

    Repo5 pointsBadges:
  • stored procs in Master db, sql server 2005

    Does anyone know where I can get a list describing, in layman's terms, all the sp_usr... stored prodedures in the Master database? New to all this and don't have the time or knowledge to decipher the TSQL behind it. Hope someone can help! Cheers

    GillsJules5 pointsBadges:
  • Upgrading Microsoft SQL 2000 to SQL 2005

    I have one server running SQL Server 2005 and about five servers running SQL 2000. Does anyone know what is entailed as far as upgrading from SQL 2000 to SQL 2005? The majority of the servers are running Win2k Server.

    Mr D50 pointsBadges:
  • SQL Server 2005 and Powerbuilder 6.0

    We currently use Powerbuilder 6.0 with SQL Server 2000. We want to upgrade to SQL Server 2005. Does anyone know if SQL Server 2005 is compatible with Powerbuilder 6.0?

    Jfel5 pointsBadges:
  • SAP SQL database cluster

    Hi Our sap configuration include two nodes on win 2003 cluster/ The cluster using us for SQL 2005 . I need to upgrade the hardware. It is possible to add two new nodes to the cluster ? It is downtime necessary if i want to replace one of the nodes ? it possible to install the sap software when the...

    Sabi1330 pointsBadges:
  • Execute a view/query is slower in SQL Server 2005 than 2000

    Hi, I have migrated a database from 2000 to 2005, updated the statistic and rebuild the index. When I run the following query "select top 500 * from myview order by name", it is extremely slower in 2005 than 2000. The myview simply does an inner join with 2 table. The name is varchar(50). Strangely...

    Db23290 pointsBadges:
  • Import AS/400 files into SQL server

    Hi I would like to know how to create a job to transfer all the files (data) from AS/400 to SQL server 2005 (keep as backup)

    Yenyen5 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