0
votes
1answer
18 views

Is there DDL viewer role in SQL Server?

I have a user that have db_datareader role in SQL Server 2008 I need this user to be able to see Stored Procedures, functions, table scripts, etc. What role is that? I don't want user to RUN DDL ...
1
vote
0answers
23 views

SQL Server 2012 licensing Downgrade [duplicate]

Our vendor is requiring us to upgrade existing accounting software db from sql 2000 to sql 2008 and my boss wants unlimited connection to db. Can i use sql 2012 per core instead of sql 2008? from my ...
0
votes
3answers
34 views

Separate SQL Server Instance or just new database?

I'm going to deploy an app whose requirement is just 'db_owner' for a database. The database itself must be created separately by the DBA. Based on how the application will work (and its simple ...
0
votes
2answers
77 views

SQL Server Database Access fails when User Granted Acess via Domain Group

On a SQL Server 2008 R2 (running on Win2003), we have an issue with logins via domain groups - login access is granted to the server instance, but cannot access certain databases on the server. The ...
0
votes
1answer
48 views

How to setup log and data files on SSD for SQL Server?

I'm setting up my production SQL server. I have two 800GB SSD disks available to me (for Windows and SQL Server). Where should I put databases' data and log files? How many tempdb files should I ...
0
votes
0answers
23 views

Can't Find SQL Server 2008 R2 SP2 uninstall option

Supposedly, the method to uninstall a service pack to SQL Server 2008 R2 (and other versions after a certain point) is through Control Panel > Programs and Features. I think it's supposed to be ...
0
votes
1answer
73 views

SQL Server Trace keeps outputting files

A consultant has come and gone to do some audit on our SQL server, and has left a bit of a mess here. The problem is that he did things that we don't know anything about. In the C:\Program ...
2
votes
1answer
113 views

Upgrade Expired SQL Server 2008R2 Evaluation to SQL Server 2012

We have been working on developing several SharePoint sites as a POC using the evaluation versions of SharePoint 2013 and SQL Server 2008R2 Enterprise Evaluation. POC worked, went into limited ...
0
votes
0answers
41 views

Access violation on inline function with CTE

Heh, that's weird. I have simple table type and inline table-valued function. When I try to run or compile this batch, I got c0000005 EXCEPTION_ACCESS_VIOLATION ! create type M1List as table (ID ...
3
votes
1answer
110 views

Are SQL Collations per Instance or per Database?

I have a single SQL Instance, let's say MSSQLSRV - is the collation per Instance, i.e. every database in the given instance has the same collation, or are collations set per database? i.e. multiple ...
0
votes
1answer
55 views

Performance issues with windows server, sql-server and apache

I am running into some performance issues on my server, which runs Windows server 2008, SQL Server 2008 R2, and apache. This is a purely internal website, and is accessed by a total of about 6 ...
0
votes
1answer
1k views

SQL Server linked server: “Cannot start more transactions on this session.”

i am trying to perform an INSERT operation against a linked server: DBCC TRACEON (3604, 7300) BEGIN TRANSACTION INSERT INTO LIVE.Contoso.dbo.Events (EventGUID, EventDate, LoginGUID, UserGUID, ...
0
votes
1answer
289 views

TCP/IP connection to SQL Express works on HALF of the clients in a WORKGROUP

So far I have learned the following facts about Microsoft SQL Server Express, including version 2012, and earlier versions like 2008R2, and 2008, and for the most part all the way back to SQL Server ...
0
votes
0answers
89 views

SQL Server Cannot see tables in Object Browser where Login = db_owner

A colleague is trying access a particular SQL Server over a remote link. He can login to the server (via SSMS) with the SQL Server credentials I supplied, but although he can view tables/etc in the ...
1
vote
1answer
220 views

SQL Server 2008 R2 on Windows Server 2003 - “ failed to initialize 0x84B10001”

I am trying to install SQL Server 2008 R2 Express on Windows Server 2003 and I get an error "failed to initialize 0x84B10001". Googling got me the following link - ...
0
votes
1answer
113 views

Error in trying to delete a local publication for DB replication

I logged in in db ad sa (super admin). I want to remove a publication made using management studio wizard (right click on Replication/Local Publications/ New publication) After trying to delete I ...
1
vote
0answers
79 views

SQL Server: Worse performance on a new server

We've been on a dedicated server (single quad-core, 6 GB RAM) and are moving to a new dedicated server (2x hex-core, 32 GB RAM). Both are Windows Server 2008, SQL Server 2008 R2. The performance on ...
2
votes
1answer
156 views

SQL Server cannot be reached by name only by IP

I have several computers (XP) connected to domain controller (2008R2). Last time I had to change IP address of the SQL Server 2008 R2 (simple instance, no clustering or replication). DNS has been ...
1
vote
1answer
103 views

SQL Server account disabled even in single user mode

I'm integrating with a third-party product via its SQL Server 2008 R2 database. In a previous version, I was able to access the database via SQL Server Management Studio and SQLCMD as a Windows ...
1
vote
1answer
2k views

How to enable Ad Hoc Distributed Queries in SQL Server 2008 R2

When I run a query with OPENROWSET in SQL Server 2000 it works. But the same query in SQL Server 2008 generates the following error: SQL Server blocked access to STATEMENT ...
0
votes
1answer
98 views

Cannot see linked server properties in SQL Server 2008 R2

I configured a linked server in SQL Server 2008 R2; mirroring what currently exists in SQL Server 2000. When viewing the properties of an existing linked you, you cannot see (or edit) any ...
0
votes
1answer
104 views

unable to connect to remote sql server from SHDSL router

Got a new leased line network to our office that came with a SHDSL router (Watson). Currently, we are unable to use Sql Server management studio to connect to remote Sql databases. It errors out ...
0
votes
1answer
120 views

Things to consider when applying hot fix to production server

We are currently using Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) as our production data warehouse database. I ...
0
votes
2answers
457 views

Advised auditing method for MS SQL to track changes made to a specific table by a specific user?

What is the best method for tracking changes or logging the queries done to a table by a specific user when the person is using Management Studio? I'm using 2008 R2 Express Edition and want to ...
1
vote
1answer
114 views

Will more memory help my CPU-peaking SQL Server 2008 R2

I'm supporting a system running against a SQL Server 2008 R2. The server is a single-CPU box with 8 GB of memory. As traffic has increased, the server has started saturating, peaking to 100% CPU ever ...
1
vote
2answers
1k views

Unable to start sql service when TCP/IP is enabled under SSCM - SS Network Configuration

in the Console , SQL Server Configuration Manager I get error 10048 when start sql service and this in event history: The SQL server service terminated with server-specific error. Only one usage ...
0
votes
2answers
123 views

Differential backup of new sql database fails until full backup is made

I have setup a job that runs every night and makes a full backup of all databases on the server. During the day, another job makes differential backups every few hours. The problem comes when a new ...
0
votes
1answer
222 views

Sql Server database logs “missing”

Here's the problem we're having: In the applications that are using the databases we get errors like: The log for database 'redactedDatabaseName' is not available. Check the event log for related ...
-3
votes
1answer
99 views

Which is easier to configure Replication for: MySql 5.5 CE vs SQL Server 2008r2 Express? [closed]

As the question states, which server is easiest to setup replication for? My needs are: A local master and a remote (VPN connected) slave. I am no where near expert in either database so which ...
-2
votes
2answers
156 views

What replication should I use for my Sql Server

We have a dedicated server that will host our client's database for a web portal. To connect to this database, you need an ip address. I figured I'd try Merge Replication since I already have the ...
1
vote
3answers
420 views

SQL Server returning empty result sets (to busy?)

My apologies from the start, I don't have much information to go on and I am just looking for some help debugging my issue. I have 5 sites running on a Windows Server Web Edition 2008 with SQL Server ...
0
votes
1answer
533 views

Enable remote access to SQL Server 2008

I've just built a virtual SQL Server 2 node cluster using VMWare workstation. The windows cluster has been created, SQL has been installed on both nodes and added to the cluster, all latest updates ...
6
votes
1answer
4k views

How do you get the minimum and maximum memory allocation of a SQL instance using T-SQL?

I'm managing about 90 SQL Server instances and need a query to determine how much memory has been allocated to each instance. Please note, I'm not asking how to set it, just to see what it's currently ...
1
vote
3answers
3k views

SQL 2008 R2 Named Instance Client Connectivity Issues?

We're upgrading our software from using SQL 2000 to 2008 R2. Our customers will be installing an update which uninstalls 2000 and installs 2008 R2 under the same instance. So if no instance existed, ...
0
votes
1answer
112 views

Can a network failure cause a user to be removed from SQL as an authorized user?

We are trying to get to the bottom of our issue. We have a service that connects as MyDomain\ServiceAdmin to a SQL 2008 database. I believe we have just setup database mirroring too in case the ...
1
vote
1answer
2k views

Quorum Disk size for Windows 2008R2 failover

I am setting up a two node failover cluster for SQL Server 2008 R2 on Windows Server 2008 R2. Microsoft recommends minimum 512MB size LUN for the quorum disk and don't have a recommendation for the ...
2
votes
1answer
198 views

Electricity gone off while shrinking database, how can I recover my database?

While executing a shrink on a 25GB database, the electricity has gone down, and I can't access my database. It shows as "In Recovery". How can I recover it?
0
votes
1answer
61 views

Parallel Processing in SQL Server 2008 R2

I want to run my 2(two) SQL Server 2008 R2 Enterprise Edition as if one server. If one server is too busy, system should direct the requests to other server. How can I do this? Thanks..
-1
votes
1answer
184 views

Difference between SQL Server 2008 Express and Workgroup in regards to CAL's

I am currently using SQL Server Express edition, and am thinking of upgrading to SQL Server Web or Workgroup edition. My question is what restrictions will I experience with the introduction of CAL ...
3
votes
2answers
434 views

How to change max server memory in SQL Server

I was trying to change the max server memory for my database server, and I accidentally saved it as "4" instead of the number I wanted to enter. Now I can't even connect to the server. Is there a ...
0
votes
1answer
1k views

Can I downgrade SQL Server 2008 R2 Standard To Web Edition?

We are running a SQL Server 2008 R2 Standard Evaluation version. The client has decided they don't want to pay for full SQL Server standard and feel the Web edition is suitable. Can I downgrade SQL ...
0
votes
1answer
173 views

exe hangs when scheduled from SQL Agent, but fine when run by user

I have a SQL Agent job on a clustered SQL 2008R2 server on Windows 2003 Enterprise. It's an Operating System (CmdExec) step, running an executable. When it runs on schedule, the process does start up, ...
2
votes
4answers
261 views

Data file size - SQL Server 2008

I am transferring a database that i made onto a server machine, but the size of the database is around 8GB, for some reason. It shouldn't be needing so much space as i only have a few hundred records. ...
2
votes
1answer
60 views

How to set up SQL Server to offer high availability during windows updates

We have a load-balanced web farm talking to a single SQL server instance. It is easy to demote web servers, install Windows updates, reboot, and then bring them back into the fold. However, we have to ...
-4
votes
1answer
867 views

Does SQL Server 2012 Developer Edition exist? [closed]

On my server, I have SQL Server 2008 R2 Developer Edition installed, and setup don't want to upgrade it to SQL Server 2012 Express. Does SQL Server 2012 Developer Edition exist?
0
votes
1answer
213 views

SQL Server tempdb performance

I have been doing some .net performance tests on a bunch of different data access frameworks. One of the things I've noticed is that performance when accessing the tempdb table in SQL is much ...
5
votes
2answers
867 views

How quickly will SQL Server release RAM when the OS signals a low memory condition?

From the SQL Server 2008 R2 Books Online: Server Memory Options When SQL Server is using memory dynamically, it queries the system periodically to determine the amount of free physical ...
1
vote
1answer
226 views

SQL2008 Max Memory set to 10GB, Target/Total perfmon counters report it's using 1.6GB. What's up?

Running SQL2008 R2 32bit on Windows Server 2003 Enterprise with 12GB of RAM. Inside the Memory settings of the SQL instance I've got max memory set to 10000MB but it isn't going past 1.6GB according ...
5
votes
1answer
609 views

Is it possible to redirect (or create an alias) so that requests for a default instance of SQL redirect to a named instance?

Is it possible to redirect (or create an alias) so that requests for a default instance of SQL redirect to a named instance? Scenario is I have SQL 2008 R2 installed as a named instance ...
1
vote
2answers
393 views

SQL Server stops regularly on every windows restart

Edit 3 & 4 Added Although the SQL Server instance is set to run automatically and TCP also is enabled in its Network Configuration, the SQL Server is stopped after each system restart. I have to ...