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
73 views

Limit user options on CREATE / ALTER database

Is there a way to limit the database settings that a user can edit, lets say auto grow and owner settings. For example I want a user to be only able to modify tables, functions, stored procedures, ...
0
votes
3answers
53 views

Sql Server 2008 .NET Administration API

Is there an API that has built in functions/methods to manage a SQL Server Host? You could just connect as sysadmin and execute the sql commands, but i think there is something out-of-the-box for ...
1
vote
3answers
112 views

I cant reach my new SQL instance

I was using a older version of SQL on my server, and it worked fine when only typing the servername,, I could directly connect to the server, I recently installed a new instance of SQL, and Iam ...
1
vote
1answer
47 views

Any gotchas to installing SQL Express 2008 after SQL Server 2008 on same machine?

Are there any particular issues to watch out for? This is for my development machine so I will be debugging against both SQL Express 2008 and SQL Server 2008. Is the same SSMS used to connect to ...
0
votes
4answers
3k views

Performance Monitor w/ SQL Server - how many counters is too many?

I'm doing some performance analysis using the built-in Windows Performance Monitor, both on general hardware and SQL Server. I've been reading a lot about which performance counters to use; in ...
0
votes
1answer
9k views

Installing SQL Server 2008 R2 32bit on 64bit : WoW64 error

It looks like it's possible for 2008 SP1: previous question. But what about current newer 2008 R2 version? We plan to use single 32bit Express edition package to install on every machine. However, ...
2
votes
1answer
562 views

Adding new article to transactional replication gives error at subscriber

I have a updatable transactional replication set with SQL Server 2008. Everything is working fine. I added a new table to the existing publication through sp_addarticle followed by ...
1
vote
3answers
145 views

High Availability on SQL Server (Suggestions)

We have a database intensive Java application. The DB we use is SQL Server 2008. We are thinking of shifting our Java application to a 2-3 node load-balancing cluster. We have frequent application ...
2
votes
1answer
99 views

SQL Server 2008 Management Studio Add-In for missing where clauses

It hasn't happened to me in a long time but I wrote an update statement and forgot to write the where clause. It was recoverable but a little piece of me still died. Are there any existing add-ins to ...
1
vote
4answers
313 views

RAID Configurations for MS SQL 2008

I am building a SharePoint 2010 farm with MS SQL 2008 R2 (STD) for the backend. The H/W is: PowerEdge R710 32 Gb RAM 4x 146 GB Hard Drives 1 additional 146 GB Hard Drive (hot Swap) My plan is to ...
1
vote
5answers
2k views

Why does SQLServer 2008 R2 take hours and hours to uninstall?

Yes, hours. As in 5, maybe 6 hours. I am sitting here staring at the uninstall progress bar stuck on 80%.
1
vote
2answers
492 views

Cluster setup recommendation for a Java-WebSphere-SQL Server application

We currently have a Java based web application that runs on WebSphere and accesses SQL Server 2008. The application requires frequent code and file changes and hence we update the EAR files in ...
0
votes
1answer
483 views

SQL Server 2008 Trial to full version?

I have a web-server that has no accessible DVD drive, but have a license for SQL Server 2008 on disc... Uploading the entire contents of the DVD is proving to be nigh-on impossible, so was wondering, ...
0
votes
2answers
230 views

SQL 2008 Web Edition for Intranet web sites [duplicate]

Possible Duplicate: Can you help me with my software licensing question? Can I use the SQL 2008 Web Edition for internal web sites (intranet), used only internally from my company, and not ...
1
vote
1answer
447 views

Install my own SQL Server 2008 copy on Amazon

Can I install SQL Server 2008 Standard Edition that I got though BizSpark on Amazon EC2?
0
votes
2answers
2k views

SQL Server 2008 default date format

I'm trying to set the default date format per server instance, but i only find examples that set the date format per session. It's is possible to do the former through T-SQL? Thanks in advance.
1
vote
2answers
394 views

Is there any way to see who deleted a view?

In SQL 2008, is there any way to see details about a deleted view. In particular who might have done it or at least when?
0
votes
2answers
432 views

Connectivity with SQL Server Express 2008 r2 and SQL Server 2000 on same machine

At first glance this may same a duplicate of Installing both SQL Server 2000 and SQL Server 2008 on the same machine, but it is not. I have SQL Server 2000 and SQL Server 2008 R2 installed on the ...
5
votes
1answer
6k views

Why does sp_send_dbmail fail inside SQL Agent jobs?

I have a simple query that I run to send email notifications to our AD account administrators when accounts have been disabled for more than 30 days. It works perfectly fine when I run it on my own, ...
2
votes
4answers
637 views

Cross MS SQL Database Engine Queries

Is it possible to have cross database queries that span databases on two different 2008 MS SQL Servers? If so, what configuration, if any, needs to be done in MS SQL? Also, could someone show me an ...
1
vote
1answer
4k views

Restore SQL Server database is hanging?

I've made a Backup from a SQL Server 9.0.4053, copied the bak file to a different computer running SQL Server 10.0.2531 and tried to restore using RESTORE DATABASE [MyDatabase] FROM DISK = ...
0
votes
1answer
980 views

Time-out occurred while waiting for buffer latch in Sql server 2008 when executing large MERGE query

In our datawarehouse we execute a MERGE query in a storedprocedure in order to synchronize our datawarehouse every night. Our database server is running Sql-server 2008 During the execution of the ...
0
votes
2answers
312 views

Copy SQL Server data from one location to another over the internet

How can I copy certain SQL server data from one server to another without opening direct access to SQL server in the firewall? I thought of things like integration services in combination with an ...
0
votes
1answer
58 views

is it possible to run a different version of sql server trial once you've already run one?

e.g. Have already installed trial version of SQL Server Enterprise Edition 2008 R2, is it now possible to switch to a trial version of the Developer edition?
1
vote
1answer
2k views

What rights do I need to run DBCC commands?

Do I need to be sysadmin to run DBCC commands on SQL Server? Or is db_owner rights enough?
0
votes
1answer
856 views

SQLServer2008 CopyDatabaseWizard Job Fails - Unable to determine if owner of job has server access

Trying to copy a SQL2000 database on server TUNA to destination server MOJITO which runs default instance of SQL2008 (at ServicePack1) via the CD Wizard. Resulting job fails on MOJITO with this in ...
0
votes
1answer
880 views

Programmatically Copy Database like SQL Server 2008 Copy Database Wizard

I need the ability to copy a database similar to what the Copy Database wizard accomplishes in SQL Server, but in a more automated (i.e. command line) fashion. I am writing a small application in C# ...
1
vote
1answer
1k views

SQL Server scheduled backup: sqlcmd.exe can't connect

I have a homebrewed backup system for SQL Server 2008 Express on Windows Server 2008. A scheduled task runs a .bat file, which in turns calls sqlcmd.exe to run a .sql file that backs up all of the ...
2
votes
3answers
4k views

How to restore a SQL Server database and shrink its files at the same time?

Let's say I have a SQL Server database whose data files have been created with an initial size of 100 GB, but it only contains 10 GB of data. A database backup will then be only 10 GB in size. I want ...
2
votes
2answers
11k views

Does Windows Server 2008 R2 standard edition support cluster?

I want to install sql server 2008 r2 edition in a cluster environment. Can I use Windows Server 2008 R2 Standard edition? Thanks.
2
votes
1answer
41 views

Adding comment (e.g. description) to views, tables, etc

Is it possible to add a short description to views, tables, etc. in SQL Server?
1
vote
1answer
419 views

SQL Server 2008 Management Data Warehouse Cache

I'm trying to save disk space on a database server. I've found there are 12GB of cache files for the data collection system, but I don't know why. Of the two data collection sets running, one is ...
1
vote
3answers
1k views

does SQL server have the equivalent of MySQL query logs

I have used MySQL for a long time and have found the general query log and slow query log to be very useful in finding out what is happening on the server, and in identifying bottlenecks. Now I need ...
6
votes
2answers
1k views

SQL Server memory constantly going up, from 1GB RAM used to 7GB in a week

I have a ~45GB database that increases rapidly (~1GB every week). So it's doing a lot of inserts; the web app doesn't have many users so reads are low right now. But I'm noticing that the RAM sql ...
0
votes
1answer
737 views

SQL Server 2008 Managment Studio Express instalation failure

I've tried to install SQL Server 2008 Managment Studio Express using the Web platform installer. Installation. The installation have failed. This was in the log DownloadManager Information: 0 : ...
1
vote
1answer
3k views

Renaming Computer name on SQL Server 2008 R2

I had to change the computer name from x to y on a sql server 2008 r2. And followed the instructions [http://msdn.microsoft.com/en-us/library/ms143799.aspx] Now when I select @@servername it shows ...
1
vote
3answers
4k views

“RESTORE HEADERONLY is terminating abnormally” error when restoring backup

When I try to restore a database backup file, I get the following error: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ...
3
votes
1answer
2k views

SQL Server 2008 - Can't Log On via local SQL Server Management Studio

FYI: OS is SQL Server 2008 (NOT R2). Yesterday, when I was trying to get Visual Studio 2010 on a remote Win XP machine to be able to debug ASP.NET over the network, I installed Active Directory (and ...
1
vote
0answers
44 views

SQL - progmatically change refresh rate for ALL publishers in replication monitor

How can I change progmattically change the refresh rate of all the publishers in the repliation monitor ? Without going into each one to change it's publisher setttings. MS SQL SMS 2008 R2 AHIA, ...
1
vote
0answers
103 views

SQL Reporting Server Authentication Issue

I have one web server & one DB server (running SQL SERVER 2008). Both the servers are in different domains. The web server is allowed to communicate(the communication takes place internally ...
1
vote
2answers
475 views

Will solid state drive improve performance of a database?

I have a Microsoft SQL Server 2008 database which contains approximately 3 GB of data. The server has 4 GB of RAM. The database is used both for reading and for writing data (lots of changes). The ...
5
votes
2answers
307 views

Under what circumstances is it a good idea to re-index tables every night?

I have inherited a number of SQL Server 2005 and 2008 systems (all running in Simple recovery mode) that each currently do the following things each night from an SQL Agent task: Backup Shrink ...
0
votes
1answer
68 views

JDBC not seeing updated table structure

I am using Coldfusion 8 which is connecting to SQL Server 2008, the problem is I have updated a table adding a new column in SSMS, but the JDBC connection is still 'seeing' the table prior to the ...
2
votes
2answers
140 views

Active Directory in Production?

We are preparing to deploy a new version of our application. The production environment will be two load balanced app servers connecting to two database servers (configured for mirroring). Now ...
0
votes
2answers
3k views

How can I diagnose the cause of unexpected restarts on a Windows Server 2003 VPS?

At first I always assumed this was the host applying updates or doing some maintenance. But after contacting the company, they assure me I would have received prior notice before any such event. In ...
1
vote
1answer
193 views

SQL Server 2008 Web Edition & CRM/LOB limitation - what does this mean?

We are reconsidering using SQL Server 2008 Web Edition, but are wondering exactly what Microsoft means by not being able to host LOB applications "such as CRM". We provide our clients with web ...
2
votes
2answers
1k views

How can I tell why my query is running so slow?

I have a query that is taking a lot longer then usual, and I cannot tell if it is stuck. The query is something like this: INSERT XXXXXX WITH (TABLOCK) SELECT * FROM YYYYYY with (NOLOCK) WHERE ...
7
votes
5answers
4k 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 ...
1
vote
1answer
428 views

How to schedule backups in SQL Server 2008 Web Edition?

I have a SQL Server 2008 Web Edition and I used the Management > Management Plans > Wizrd to schedule the backup of all my databases. I executred the task to test it and I get this error: ...
1
vote
0answers
419 views

Event viewer filtering - MS Sql server - How to filter logins from outside?

I want to filter event log to show SQL logon that was initiated from other machines, I have thousands of logins from local machine and few ones from other machines. I want to monitor that connections ...