We have a Windows Server 2003 R2 using SQL Server 2005
Within the server are Two Lan Workgroup (IP Add 192.168.1.33 and 192.168.2.33)
Neither IP has a problem connecting to the Server, their ping is ...

I have a Sql Server 2008 Standard version. Mirroring is set up on the server in full safety mode. Its been working fine till today. The transaction log back-up fails every-time with an error
"Error: ...

I have a Windows Server 2008 R2 virtual machine running MS SQL 2005 on top of a VMWare ESXi 5.5 host on a SAN datastore.
Consistently it has been "losing" 2GB of hard disk space per day and I can't ...

Anyone please help! Today is 3rd day that I'm banging my hand to solve this problem.
So the situation is, I've inherited a project which worked on SQL Server 2000, later client decided to upgrade the ...

In the process of moving/upgrading old SQL server 2005, I need to move some sharepoint PWA datafiles.
After detaching the database from the files, I am trying to copy/move the DB files from their old ...

I now have my first bigger project of my own.
I invested around 500 working hours and the project is done.
It's actual ASP.Net with C# and Linq to SQL, the platform is an MS SQL Server 2005 Express ...

I have a program in excel that connects to several sql servers using servername and instance. My question is, what would happen if there are two servers (machines) with the same servername in the same ...

I am stuck.
I've just taken over maintenance on a SQL Server...that has not been backed up in quite a while...The log file has grown to over 1.61TB...Yes, 1.61TB.
It has swallowed all available disk ...

I was just looking over one of oure less monitored databases and noticed that it hasn't archived any logs for over a month. This is what it looks like now. The current log has over 700 000 events and ...

What happens if a stored procedure is run in sql server management studio (SSMS 2012 to 2005 server) and it crashes?
I'm guessing the stored procedure continues to run?
On the other hand I have read ...

I have gone into SQL server config manager but can't get the thing to start...have some screen shots...but cant attach images since i am a newbie...it is SQL server 2005 and i can't get the instance ...

I would appreciate any ideas on this. It has us really confused. The issue seems to be environmental so we are going to host this one process elsewhere, but it is driving me crazy that I don't know ...

We have a windows server 2003 R2 machine running MSSQL 2005, and our XP workstations all run a VB6 application which calls the SQL backup utility to backup a 700 Mb database. A couple of weeks ago all ...

I have a cusotmer who sent me their database dump, which I'm supposed to import into MS SQL 2005 and have a look at.
Unfortunately, it is (I am told) from MS SQL 4.2 (circa 1992), (which apparently ...

I'm really not sure where this question would be best asked, so I'm posting this here in an IIS-specific forum, and also over in SQL Server Central for an SSRS-specific audience.
The problem that I'm ...