• 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...

    ITKE366,220 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:
  • 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:
  • 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:
  • SQL Server Table and View Index

    Hi, I was wondering if migrating a database from SQLServer 2000 to 2005 using restore or detach/attach also copies the table and view index. Thanks.

    Db23290 pointsBadges:
  • Linked SQLServer

    Hi, In oracle database you are able to link the oracle database to a SQLServer 2005 database, I want to be able to link a SQLServer 2005 another SQLServer 2005 database (not another SQLServer 2005), does SQLServer 2005 allow us to do this? Does it only allow server to server linking? Thanks.

    Db23290 pointsBadges:
  • Can’t create ODBC connection to sql 2005 instance

    I have a server 2003 two node cluster with SQL 2005 installed. The orginal instance is working fine and there is no connection problem. I have created a second instance and can connect with the SQL Management Studio. When i try to create a ODBC connection from my client os both XP and VISTA both...

    Therockatmsu15 pointsBadges:
  • sql2005 with share point 2007

    I installed sql server2005 and sharpoint 2007 for two times in two seprate windows server2003 but i give same error when i want to start share point : failed to start the database service MSSQL$Officeservers.repair this product by selecting it from the add/remove programs menu. now how can i do?...

    4425195915 pointsBadges:
  • Execute SSIS package in SQL Server 2005

    how to execute SSIS package in sql server 2005

    Sangeeth30 pointsBadges:
  • Attaching a SQL Server 2005 database to SQL Server 2000?

    Is it possible to attach a database that was created in SQL Server 2005 to SQL Server 2000?

    SQL Server Ask the Experts2,585 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