Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2008]

A version of Microsoft's database server, released in August 2008. This is different than SQL Server 2008R2.

SQL Server 2008 is Microsoft's version of SQL Server following SQL Server 2005. A list of the new features can be found here

1806 questions
0
votes
2 answers

Can Sql Server send an email alert if a RAISEERROR has be raised?

is it possible to get the Sql Server 2008 to send an email when a query RAISEERROR is thrown .. or at the very least, when a RAISEERROR with a predetermined error code or codes?
Pure.Krome
  • 6,508
  • 18
  • 73
  • 87
0
votes
0 answers

Dummy transaction to check if a system is up

We want to send a dummy transaction through our system (Application - DB) to ensure it is still up every minute. If the transaction fails we are alerted - Thereby knowing within a minute if there is something wrong with our System. If it is sent…
Axle
  • 33
  • 1
  • 6
0
votes
2 answers

Can there be two machines with the same server name (SQL SERVER) in the same network?

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 network? Is that posible? How can this be…
ia.solano
  • 119
  • 1
  • 1
  • 3
0
votes
2 answers

SQL 2008 Failure after compressing HDD

I've absent-mindedly let Windows Server 2003 compress a HDD to try and save some space. That same drive contains an instance of SQL Server 2008. Since compressing, all the Databases have taken themseleves offline. I've manually expanded the files in…
Ben Ford
  • 101
0
votes
1 answer

Restore From Database not showing database I want to pick

In Management Studio I want to restore to a point in time from an existing database. However, the databases that I can choose from in the drop down list don't include the one I want to choose. And oddly, there are databases in the list that have…
BVernon
  • 403
  • 1
  • 7
  • 19
0
votes
1 answer

SQL Port 1433 needed in SQL Server2008 IP Field for remote connection

I just installed SQL Server 2008 on my server. I do it often enough to forget what to do so I read through a couple of MS installation instructions. I installed with no issues. I tried to remote into the server from another computer using SQL…
Steve Mansfield
  • 1
0
votes
2 answers

Pointers on managing database with 4000 tables?

I'm in the middle of designing a software system storing data in about 4000 tables in Microsoft SQL Server 2008. Does anyone have any pointers to ease management of such a large number of tables? Thanks! P.S.: It's already normalized.
AJ.
  • 168
  • 5
0
votes
1 answer

SQL Server datafile growths

For SQL Server 2008 what is the maximum number of growths? And which view do I query to find that information for a datafile in my database?
user49352
  • 123
  • 2
  • 4
  • 12
0
votes
1 answer

SQL Server 2005 - My Linked Servers to it are broken now!

I'm a programmer working over a VPN. I use local databases most of the time, but my local SQL Server 2005 has "Link Server" server object pointing at the production server. This has been working great (albeit, slow over VPN) until the company had…
Brian Webster
  • 1,123
  • 1
  • 18
  • 39
0
votes
1 answer

SQL Server 2008 side-by-side with SQL Server 2012, possible issues with SAP Business One 8.81 PL:07?

We have a Windows Server 2008 R2 Enterprise system running SQL Server 2008 Enterprise (x64) version 10.0.4067.0 and SAP Business One 8.81 PL:07. We would like to install a named instance of SQL Server 2012 (side-by-side with 2008), leaving all the…
Ethan
  • 103
  • 5
0
votes
1 answer

Real trouble for opening port in SQL Server 2008

I'm having trouble trouble opening port in SQL Server 2008 R2 Express Edition (http://www.microsoft.com/en-us/download/details.aspx?id=30438) even by disabling the Firewall. I also installed the official requirements needed on the instructions…
Guillaume Néry
  • 11
  • 1
0
votes
1 answer

Backing up database fully from remote server, and restoring to another remote server

I currently have three copies of my website (Live, Staging, and Development), with the database for each on three separate servers. More often not, a bug will appear that requires an up-to-date database, so I'll RDP into the Live DB, go into SQL…
AlexT
  • 123
  • 4
0
votes
3 answers

SQL Instances and Servers

I have two installations of SQL on two seperate boxes (I have "Inherited" these). A SQL 2005 Installation, with instance called SQL2005 - I connect to this via SQL Studio Manager and when I connect to Servername I put: SERVERNAME\SQL2005 A SQL 2008…
PnP
  • 1,684
  • 8
  • 39
  • 65
0
votes
1 answer

Not able to connect to the MS SQL server

Am getting error as show below. It was working fine with no issues but recently started taking long time in query execution and connection: Cannot connect to . =================================== Timeout expired. The timeout period…
storm123
  • 1
  • 1
0
votes
1 answer

Need to DROP TABLE from 100s of SQL backup files

I have MS SQL Server 2008 available to me. Is it possible to script (perhaps with Powershell?) the processing of all my backup files to drop a table (or two) from each one? I used 7-Zip on the command line to encrypt them so this script will have to…
Chris76786777
  • 979
  • 5
  • 21
  • 35
1 2 3
…
99 100