SQL Server 2005

Increasing Processors of SQL Server 2005 in VM

Hi, We are about to increase the number of processor on a Virtual Machine from 1 to 2 for one of our clients, will this affect the SQL Server 2005 which installed on the Virtual Machine, just wondering if are any issues to look out for, and if anyone has done this before? Thanks.

Problem with Download-only Articles in New Subscription of Merge Replication

Hi, I have a Publication in a SQL Server 2005 Merge Replication with Mobile Devices. To explain my problem follow this example: I have an Article in Download-Only with 100 rows. When I start new subscription I look, in the Replication Monitor, that Process start with "Insert 300 rows" for this...

Which version of SQL will work best?

We have a small but critical application that is accessed by about 30 - 40 users on our network. We want to set up a SQL environment to run the database, but the application accessing the data is locally installed on each users machine. Users will access the db over our network using an ODBC...

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.

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

Adding processor to SQL Server 2005

Hi All, We are about to add an additional processor to one of our SQL Server 2005, just wondering if there are any downside to doing this and if this a low risk task to do, i.e. we won't encounter any problem after doing this? Thanks.

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

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

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

MS SQL SERVER (BKUPEXEC) Services wont start

Hi ALL, Background: Windows 2003 Server returned the error missing or corrupted file after the server was found OFF due to possible power problems (Server is on a UPS). Ran a CHKDSK on the server and it fixed the missing or corrupted file problem and server now up and running. Is seems that my...

Transaction Log - SQL Server 2005

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

Connecting to a SQL Server 2005 database through LAN

I am trying to connect to my SQL server 2005 database on my server. I open SQL server 2005 management studio and try to set the server name to IPADDRESS\SERVER3 (the name of the server) but this doesnt work. I have also tried with connection strings in VB and these dont work either

Replacement of CROSS APPLY statement

1. I am running query in which cross apply operator is used 2. That same query exceutes more than 10 times 3. Due to cross apply it increase the time to excute the report

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