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

learn more… | top users | synonyms

0
votes
1answer
2k views

Unable to run query in SQL Management Studio because of JIT debugging error

Recently I have built a Windows server 2008 and installed SQL Server 2008 and Dynamics CRM 2011 on it. Everything is working fine but when I open the SQL Server management Studio and try to open a new ...
0
votes
0answers
11 views

Calculate datediff between events on different rows

I have the following table selected and want to be able to calculate the datediff between events within the same job. Note: OperationID=event, ServiceReqID=Job OperationID is from ...
0
votes
2answers
1k views

SQL 2008 install failed - Could not find the Database Engine startup handle

My SQL 2008 install failed, I'm getting this error: Could not find the Database Engine startup handle This happens after uninstalling SQL Server 2008 and trying to install SQL Server 2008 R2, any ...
0
votes
1answer
1k views

SQL Server 2008 (SP2) Exception has been thrown by th target of an invocation (mscorlib)

The following error started after renaming my SQL Server 2008 (SP2) Instance with a new name. Now unable to open the maintenance task that previously running with the old instance name, also the web ...
2
votes
1answer
1k views

How to backup/restore excluding filestream varbinary in SQL Server 2008?

There is an application used in a production site that uses SQL Server 2008 as its DBMS. The database schema uses Filestream Varbinary to save binary data on the filesystem instead of directly into ...
1
vote
2answers
4k views

SQL 2008 R2 replication error: The process could not connect to Distributor

I have two servers running SQL 2008 R2 Standard, each with an instance named "MAIN". I have a small test database on my primary server (one table, 13 rows) that I want to replicate to a second server ...
1
vote
1answer
18 views

MICROSOFT SQL SERVER MANAGEMENT STUDIO 2008R2, new schedule, what it does and where it goes?

I just clicked sql server agent -> new schedule -> named it thisisjustatest and scheduled it to run tomorrow at 1 am. I would like to find that schedule and delete it. I can't find it anywhere. The ...
0
votes
2answers
1k views

Installing SQL Server 2008 SP2 fails in 2003 cluster setup

When I try to install SP2 (or simply "repair" the SQL Server installation), the dependency check finds the following problem: Rule "Not clustered or the cluster service is up and online." failed. ...
0
votes
1answer
2k views

Cancel/Kill SQL-Server BACKUP in SUPSPENDED state (WRITELOG)

I have a SQL 2008 R2 Express on which backups are made by executing sqlmaint from windows task planer. Several backups ran into an error and got stuck in state SUSPENDED with wait type WRITELOG. How ...
3
votes
1answer
5k views

The OLE DB provider “SQLNCLI10.1” has not been registered.; 42000

I have a SQL Server 2008 Analysis Services Project. In the Data Source View I have a Named Query which references a single Data Source containing three tables. The Project processes successfully and ...
0
votes
1answer
380 views

Dynamics AX 2009 Falls Over when SQL Cluster Rolls

We had an issue on one of our production database nodes which caused it to fail over to another. This caused a brief outage whilst the service rolled. This temporary glitch however was enough to ...
2
votes
3answers
1k views

What SQL Server Query will set perfmon counter “Longest Transaction Running Time” > 0

I'm trying to decide whether this performance counter is worthwhile monitoring: \\SERVER\MSSQL:Transactions\Longest Transaction Running Time. So during testing I tried to create some long running ...
4
votes
9answers
17k views

How do I solve MSSQL 2008 install error, “The MOF compiler could not connect with the WMI server”?

Possibly related to: SQL Server 2008 Install fails error reading etwcls.mof After manually removing MSSQL 2008 from my system (uninstall failed to remove two instances), I receive the following ...
-2
votes
4answers
11k views

How to make SQL Server visible on internet? [closed]

This is embarrassing for me, but I have no idea what to do. I want to connect to SQL server from my home and field office; what else should I tweak? I could use VPN (it works), but I* prefer to ...
1
vote
1answer
1k views

Restore SQL 2008 database fails with error on page xxx:xxx

This is the situation: Got a full backup (.bak file) of a SQL 2008 database, with partitions. The .bak file is 100gb. I need to restore this database on a different server, to a new database. ...
1
vote
2answers
4k views

Could not continue scan with NOLOCK due to data movement during installation

I am running Windows Server 2008 Standard Edition R2 x64 and I installed SQL Server 2008 Developer Edition. All of the preliminary checks run fine (Apart from a warning about Windows Firewall and ...
3
votes
2answers
5k views

AclPermissionsFacet fault install SQL-2008-R2

While attempting to do an installation repair of SQL-2008R2, I'm failing the pre-check rules. Module that is failing is AclPermissionsFacet - with this message "The SQL Server registry keys from a ...
6
votes
4answers
12k views

Is there a way I can use SQL Server management studio to find all columns that have column names that contain a certain substring?

I'm using SQL server management studio 2008. I have a huge legacy database with thousands of columns. It would be nice if I could search for all columns whose names contain a certain substring. Does ...
1
vote
1answer
2k views

Exception Enumerating SQL Server Instances with SMO WMI ManagedComputer

I'm trying to use the SMO WMI API/objects in PowerShell 2.0 on Windows 7 with SQL Server 2008 R2 installed to get a list of SQL Server instances on the local computer using the Managed Comuter object. ...
0
votes
3answers
3k views

Disable remote access for one user/database in SQL Server 2008

is this possible to disable remote access for one user or database in SQL Server 2008? Thanks
0
votes
1answer
4k views

Error: Package 'Microsoft SQL Management Studio Package' failed to load. In SQL Server Management Studio

I had installed SQL Server 2008 R2, the installation was succesful. But I can't open the Management Studio because this error is shown: Package 'Microsoft SQL Management Studio Package' failed to ...
0
votes
1answer
21 views

SQL Server - Database Transaction Log Backup. Appended or seperate files?

we have 30 productions databases in our SQL server. top big DBs are 60GB, 40GB, 8GB, 5GB and the rest are 1GB or less. we have incremental transaction-log backup set-up currently every-hour by ...
2
votes
5answers
2k views

Database Mirroring Properties Page Missing

I am having a problem with one database on my SQL Server 2005 production server. A number of databases are already set up for mirroring, however when I right click and go to properties in SSMS, on ...
0
votes
1answer
2k views

Unable to save view: “There is already an object named 'Quotes' in the database.” - Error 1222

I often get the aloof error message above, after trying change a view in SQL Managment Studio 2008. I right-click on a view, select 'design', make a change (or not), and click the Save button. It ...
2
votes
1answer
2k views

SQL Server instance shuts down

I'm currently developing a new ASP.NET project hosted on a Windows Server 2008 RC2 with an SQL Server 2008 Express database. I have three SQL Server instances (for different purposes) running which ...
1
vote
1answer
19 views

How to handle replication post SQL Server 2000/2008 migration?

I have two servers; server A host SQL Server 2000 and server B ( a remote server) host SQL Server 2005. I replicate data between these two servers using transactional replication. I recently migrated ...
3
votes
0answers
59 views

Exit code 0x84C40013 in silient installation of SQL 2008 service pack 3 installation

Following Command is utilized for installing SQL SP3 pack in Windows server 2008 R2. start /WAIT C:\Temp\SQLSP3.exe /quiet /IAcceptSQLServerLicenseTerms /Action=Patch /AllInstances This complete ...
1
vote
2answers
87 views

How to free up disk space on a drive which has BiztalkMsgBoxDB_log file in it

I have been asked to analyze a issue regarding one of the biztalk servers. I was asked to free up space on a particular drive, where I found the only file BiztalkMsgBoxDB_log.bak is taking up close ...
3
votes
2answers
28k views

how to change sql server product key

my version of sql server 2008 Enterprise edition has expired and I have a new key how to change the old key without uninstall or any modification to the installed server or instances.
21
votes
4answers
91k views

Adding an administrator user to SQL Server 2008

How do you add an administrator user to SQL Server 2008?
0
votes
1answer
621 views

SQL service log on account

I installed SQLServer 2008 Express and pretty much took all the defaults. After about a week of running an app that hits this database I changed the administrator password for the server. About a day ...
1
vote
0answers
12 views

Repeatedly prompted to restart the computer when installing SQL Server 2008 R2 on a x64 Win 8.1 machine

I am trying to install SQL Server 2008 R2 on a Win 8.1 x64 bit machine. When running the installer, I get the Reboot Required check failing the install. I have tried rebooting, no difference. I ...
8
votes
6answers
12k views

How can I have SQL Server Management Studio 2008 connect to my instances automatically?

I'm running a server with 3 database instances. Right now, when I open Management Studio, it opens the "Connect" prompt that lets me choose which instance I want (or connect to anything else). Would ...
0
votes
0answers
29 views

Running SQL Server based Program Via VPN

I have recently set up a site-to-site VPN. Location A has a PC running windows 7 (we'll call it Computer1) that acts as a server for a point of sale program. The program uses SQL Server 2008 to store ...
10
votes
2answers
73k views

What is a SQL Server instance?

When I install SQL Server 2008 Express in prompts me to create an instance and aborts if I don't. Then I see that information in an entry in Sql Server Configuration Manager on SQL Server Services. ...
8
votes
5answers
8k views

SQL Server Timeout on first attempt

I'm having a strange issue where I try to attach to SQL Server 2008 running on a second computer (both machines running Win7 64-bit), either through the Data Sources in Visual Studio or via the SQL ...
0
votes
2answers
5k views

windows could not start sql server ( error 1067 the process terminated unexpectedly)

when i strat sql server 2008 in y computer this error windows could not start sql server (mssqlserver) servise on local computer error 1067 the process terminated unexpectedly.
0
votes
0answers
1k views

Error in install sql server 2008 rn [closed]

When running the SQL Server 2008 setup, I receive the following error message: TITLE: Microsoft SQL Server 2008 R2 Setup The following error has occurred: Unable to open Windows Installer file ...
2
votes
0answers
869 views

SSMS stuck scripting database objects

SQL Server Management Studio sits stuck, after scripting all objects in a database. Except it didn't script all objects in a database. i scripted all the objects in an SQL Server 2008 database from ...
3
votes
5answers
2k views

Enable row level compression on all tables and indexes

One of the (optional) requirements for the Works With SQL Server 2008 test is that row level compression is enabled on all tables and indexes. We have an existing database with a lot of tables and ...
3
votes
3answers
9k views

MS SQL Server 2008 sa account locked out and Windows Authentication login is greyed out

The sa account got locked out and even though mixed mode authentication is enabled. When I select "Windows Authentication" the Username and Password fields are greyed out. The username field contains ...
4
votes
2answers
6k views

Does splitting out Data, Logs, and TempDB matter using a SAN with SQL 2008

I'm not a server admin. So be gentle. But I was just at a conference and in one of the training classes the Instructor explained some SQL DBA best practices. One of which was to separate out ...
9
votes
2answers
46k views

How can I see who is connected to my db?

I was trying to rename a database and it said that it needed to be exclusively locked to perform this operation ... How can I check who is connected to it?
-1
votes
2answers
58 views

Database sql server Mirroring or replication

I have SQL server 2008 R1 with standard edition. I have a large database i.e. 500GB that i.e. growing rapidly 10GB a month .It is a cloud based solution. We have another data center where the ...
0
votes
5answers
5k views

Database planning - Multiple Schemas vs Multiple Databases vs Single large database vs Partitions

We design websites for Realty companies. The websites are used only to display the information and all the websites share a common template. We have around 150 websites for different customers. Some ...
0
votes
6answers
6k views

cannot connect to sqlserver 2008 express on windows 2008 server r2

windows 2008 server r2 installed sql server 2008 express sp1. also installed sql server management studio. how ever am not able to connect to sql server thru the management studio. error message show ...
1
vote
1answer
60 views

How do I see processes from all users in SSMS2008?

I only see my own connections/processes in the new activity monitor... whereas in the earlier versions of SSMS you could see everyone's. Do I need to change a setting or something?
-1
votes
1answer
4k views

Restore SQL Database From BAK File using a SQL Query

I have my database backing up to the hard disk in the format of BAK file. I am trying to restore that backup, but I unable to do so. Here is my query: ALTER DATABASE DBASE SET SINGLE_USER WITH ...
0
votes
2answers
668 views

Is an ms-sql/excel connection two way?

When I connect to an external data source on my MS-SQL server using Excel, is it solely an import, or can I edit the data residing on the MS-SQL server right from Excel? I have a user (the DBA, funny ...
2
votes
1answer
103 views

Is there any gain from using multiple files in SQL server for raid-5 configuration?

We are setting up a server with five 240GB ssd as raid-5 configuration into one logical drive. We're planning to partition the logical drive into four drives on windows server. In SQL server, would ...