SQL Server 2005

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

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 :-)

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

VB.NET - Can't insert data into database.

I used insert command it worked successfully that ur data has updated.But it is not showing in the database Plz look in the below code and tell me where iam wrong Imports System Imports System.Collections Imports System.Data Imports System.IO Imports System.Xml.Serialization Imports...

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

SQL 2005 Password

I inherited SQL 2005 server from a previous employee and the SA password is currently stored and saved in the GUI. This has allowed me to do my job up until now. I have what I think to be the password but I am unsure if it is correct. I am afraid to remove the stored password to check. Is there...

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

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?

Invalid String or buffer length ERROR

I am trying to connect to SQL server 2005 express edition using JDBCODBC bridge driver. I have succesfuly configured the data source but when I use DriverManager.getConnection("jdbc:odbc:sql")-->sql is the data source name.. I catch this Exception.. Many thanks in advance

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

Connecting VB2008 to SQLServer2005

How to connect VB2008 with SQLServer2005 through coding.. Not through OleDBAdaptar.. Also Let me know the code for Add,Edit, Delete & Save in VB2008

SQL Server 2005

CAN ANYBODY HELP ME "HOW TO ASSIGN A SQL-STATEMENT IN A VARIABLE". FOR EXAMPLE : TO ASSIGN A STRING IN A VARIABLE, WE DO LIKE THIS: DECLARE @A AS VARCHAR(20) SET @A='HAI' PRINT @A OUTPUT: HAI SIMILARLY HOW TO ASSIGN A SQL-STATEMENT IN A VARIABLE.

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

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

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

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.

how can i retrieve the data from sql-server2005 from multiple tables in two combo-boxes in vb6.0 using programming code

how can i retrieve the data from sql-server 2005 from multiple tables in two combo-boxes in vb6.0 using programming code

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)

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.

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