This tag is for SQL Server 2008, major build version 10.00.xxxx.

learn more… | top users | synonyms (1)

1
vote
2answers
346 views

Protect SQL Server from hackers

Today, my SQL Server 2008 is attacked by hacker from IP address in China [4300 Login failure in last 7 hours]. I contacted GoDaddy support and below is what they told me. EXEC sp_readerrorlog 0, 1, ...
0
votes
0answers
57 views

SQL Server query result: missing zero before decimal point for -1 < float < 1

I have SQL Server 2008 Express with linked Oracle db. When querying Oracle from SQL Server, I receive for example ,96 instead of 0,96 for float type columns. Any idea how to configure this on ...
0
votes
1answer
159 views

SQL Server Error - HRESULT E_FAIL has been returned from a call to a COM component

I have a huge 200MB .SQL file. When I try to open this in SQL server management studio 2008, I get the error -Error HRESULT E_FAIL has been returned from a call to a COM component. What could the ...
6
votes
1answer
800 views

Bitmask Flags with Lookup Tables Clarification

I've received a dataset from an outside source which contains several bitmask fields as varchars. They come in length as low as 3 and as long as 21 values long. I need to be able to run SELECT queries ...
7
votes
3answers
2k views

SQL Server 2008 datetime index performance bug

We are using SQL Server 2008 R2, and have a very large (100M+ rows) table with a primary id index, and a datetime column with a nonclustered index. We are seeing some highly unusual client/server ...
3
votes
1answer
1k views

“Prelogin failure” when attempting to run stored procedure across linked server

I'm getting the below error when attempting to run a stored proc across a linked server that is going from Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) to Microsoft SQL Server 2008 (SP2) - ...
9
votes
3answers
1k views

using *tables* as Table-Valued Parameters (TVP)

MS SQL 2008 supports TVP: a useful feature for bulk uploading data to a stored proceedure for processing. Rather than create a user-defined type, is it possible to leverage an existing table ...
2
votes
1answer
43 views

How to find out if anything is running as or relies upon a user account in anyway before removing it?

Running SQL Server 2008. So I need to get around to removing an old users account, but I'm worried that just disabling or deleting it right away might cause some things to stop working properly if ...
0
votes
1answer
66 views

Transactional Replication-Creating New Publication (for 800GB SQL Server 2008 DB) taking too long [closed]

I am trying to setup a transactional replication (which was done successfully in two earlier attempts but had to redo this time for some specific reasons on the remote distributor database server) ...
2
votes
1answer
1k views

SQL Server Management Studio Change User Server Roles to sysadmin?

in my local machine I have SSMS (SQL Server 2008 R2). For user xxxx Server Roles are as public. when i try to change it to sysadmin it through error User does not have permission to perform this ...
9
votes
1answer
3k views

Are there any risks to granting users SQL Server SHOWPLAN permission?

I'm doing some performance tuning on a large SQL server 2008 database, and the IT group is unwilling to give SHOWPLAN permission. In the past, "Show Execution Plan" has been the most effective way to ...
4
votes
2answers
2k views

SELECT permission on view querying table from another database

SQL Server 2008 R2 SP1 My company uses the Great Plains (GP) financial system with several customizations. Our Value-Added-Reseller (VAR) for GP has setup most of these customizations in a separate ...
0
votes
2answers
94 views

SQL server 2008 Express x64 in windows 8.1 fail [duplicate]

I've been download sql server express x64 version in this I just install new windows 8.1 x64 vl version and install trial KIS for anti-virus. After i install sql server but it's not working and ...
-2
votes
0answers
31 views

log shipping backup job getting failed frequently

Even i am facing similar issue some of the log backups are getting failed for the same reason stated above the first possibility that came to my mind was the same it could have been a network issue or ...
0
votes
1answer
169 views

Validate each parent intermediary is also a parent to itself

I want to validate where each parent intermediary is also a parent to itself. So this query should return invalid parents in SELECT if table has any. I need to do is first of all get all parents ...
1
vote
1answer
107 views

Need advice on abnormal login auditing

Recently i am facing some slow issue for my web application. And i have check my visitor report and it shows normal traffic rate as usual. And then i check my db login auditing and find below login ...
0
votes
0answers
17 views

dbcc shrinkfile not reducing size of log file in sql server 2008

I am shrinking log file of SQL Server 2008 R2 database, but it is not working. I was using this code: ALTER DATABASE [database] SET RECOVERY SIMPLE DBCC SHRINKFILE(DATABASE_LOG, 20) ALTER DATABASE ...
2
votes
0answers
38 views

Cross-talk with temp tables with SSRS over a shared data source?

I have a data source that is setup to store credentials on the report server and to use them when running reports. Given the following factors, I'm concerned about reports that use temporary tables in ...
3
votes
2answers
1k views

SQL Server - In Recovery

Was uploading a few hundred thousand rows in my SQL 2008 R1 database and have come in this morning to an "In Recovery" message next to the database name in SQL Management Studio. I've tried a DBCC ...
1
vote
1answer
73 views

Take database backup of a SQL server 2012 from local SQL Server 2008 R2

I have a SQL Server 2012 installation that has some issues with SQL Server Agent because of which I cannot schedule a job or a maintenance plan to take backup. What I am trying to do is to create a ...
1
vote
1answer
64 views

Create USER and LOGIN permissions

What permission should I give to a user or role so that it can Create Login or Create User in database.
6
votes
0answers
175 views

Is this a race condition or bug in sql server using serializable TIL with updlock? [closed]

I've been staring at this problem for almost a week now. I'm getting a deadlock in some query, and I've reduced the problem to these reproducible steps: Create a database with: create table offering ...
4
votes
2answers
85 views

Why shouldn't a pre-hashed password be used with CREATE LOGIN all the time?

(For the purpose of this question, assume that I only need to support SQL Server 2008 and higher. Or to future-proof this question, let's say recent, current, and near-future versions.) The ...
6
votes
1answer
573 views

Service Broker: Queue Monitor is dropped after poison message

I have searched everywhere and there isn't an answer online. There is one similar question on stackoverflow but it's not exactly the same and it has no accepted answer. When I setup event ...
1
vote
1answer
38 views

Alternatives to joins using Linked Server and OPENQUERY

In my environment, we have a server that stores sales data and another server that stores our HR data. For some reports, we need to combine sales data with employee data. Our sales server contains ...
5
votes
3answers
314 views

What is the easiest way to use a SQL Server backup to retrieve just a few rows?

I need to manually retrieve a few rows from a SQL Server 2008 database backup. Normally I create a new database, restore the database backup to the new database, and run my queries. The database is ...
1
vote
0answers
47 views

Side effects of using updlock lock hint?

I was just exploring UPDLOCK hint in SQL-Server 2008 and I found it is very useful in avoiding certain deadlock scenarios. There are always some side effects when using these types of lock hints but I ...
1
vote
2answers
102 views

Improving a search query

I have a query for search function. Basically search function allowed user to define what they "have" and "want". Then this query will filter out all the possible result which created by other user. ...
3
votes
1answer
42 views

Can't update trigger because of activity

Trying to add a line to a trigger that is attached to a table that is constantly in use ALTER TRIGGER [dbo].[name_of_trigger] ON [dbo].[name_of_table] AFTER UPDATE BEGIN IF ORIGINAL_LOGIN() in ...
3
votes
1answer
806 views

SQL Server 2008 Setup Error 0x80070490

I am trying to install SQL Server 2008 x64 on Windows 2008 R2 and keep getting the following error: SQL Server Setup has encountered the following error: Element not found. (Exception from ...
3
votes
2answers
169 views

Databases entering “In recovery” mode on restore

I am facing an issue while restoring the database. I have many dump files in a folder and I try to restore them one by one to a database xyz, perform some update operation and continue my restore ...
1
vote
1answer
188 views

Increasing time-out period for schema compare (windows server 2008, Sql Server 2008 R2 and VS2012)

I need to increase the time-out period for schema comparisson using visual studio 2012 to compare two sql server 2008 r2 database on a windows server 2008. I believe this is somenthing I need to set ...
1
vote
1answer
166 views

SQL Server replication conflicts after migration from 2000 to 2008

I got a suggestion over at Stackoverflow to post here....greatful for any and all help. Please bear with me I think this might take a while to explain. For many years now my company has hosted a ...
1
vote
1answer
74 views

Poor performance on inner join using dates and between

I am having trouble optimizing a query that does an inner join using a date range. The purposes of the query is take daily data and summarize by week. Select pcw.EndDate WeekEndDate, h.Store, ...
1
vote
0answers
53 views

What SQL Server Edition to use [closed]

I am a programmer and I have been asked to identify a Sql Server Edition suitable for our intranet web site. There will be 15 users connecting to web site. But we use one windows account to connect ...
1
vote
2answers
977 views

Connect a linked server to MS Reporting Service?

I've got a MYSQL server setup as a linked server in MS SQL server 2008. Can someone tell me if it is possible to generate reports from this server? How do I connect it to Reporting Services?
0
votes
1answer
26 views

Rebuild Index in system database

I use SQL Server and have multiple indexes in system database whit index fragmentation 30% or more. I don't know that SQL server manage system database index automatically or I want to manage them. ...
0
votes
0answers
42 views

Sql Azure: The session limit for the database is 8000 and has been reached

I am getting following exception in SQL Azure, my SQL Server database is a web version, and I am getting this error in SQL Server Management Studio (when connecting). Also this is happening when ...
1
vote
1answer
21 views

cannot see logins subfolder

Forgive me for my lack of dba experience but I can't find the answer anywhere. I'm working remotely on a third party to a client that asked for a login, I created the login but there's problems with ...
4
votes
2answers
141 views

Update Statement takes forever to complete [closed]

I have table around 1250000 records, and 80 columns Table Structure CREATE TABLE [dbo].[Table] ( [Column1] [int] IDENTITY(1, 1) NOT FOR REPLICATION NOT NULL, [Column2] [int] NULL, [Column3] [int] ...
3
votes
2answers
202 views

Are there advantages to using temporary tables over derived tables in SQL Server?

I read the derived tables have better performance than temporary tables, but anyway many SQL Server developers prefer the second ones. Why? I must do queries with large data (millions records) and I ...
0
votes
1answer
35 views

How to know my workload type

Is there any tsql-query/DMV through which I can tell my workload type on database, whether mostly Reads or mostly writes happening? Thanks in Advance.
1
vote
1answer
20 views

How to fix SQL Server instances with different builds on same server?

I have a Windows 2008 box and there are 5 instances of SQL Server 2008 Standard installed. After that, SQL Server service pack patched. Weird thing is: the builds for those instance are different. ...
2
votes
2answers
7k views

Generate create script for all indexes

I am working on documenting my databases, and I would like to create a list of all of the indexes in my database. The reason I want to do this is so that I can track changes to my indexes overtime. ...
5
votes
2answers
2k views

Reading SQL Server 2008 transaction logs

I have a requirement for tracking some usage on a table that will be getting retired in the next year and feel that I could get the pertinent data (stored procedures and in-line sql being used against ...
0
votes
2answers
37 views

DMV queries for capturing most frequently used queries and worst performing queries [closed]

Can anyone provide dmv query to achieve the following Query to capture frequently used stored procedure Query to capture frequently used ad-hoc queries Query to capture worst performing stored ...
1
vote
1answer
16 views

How to capture workload from production and replay on test env

I want to perform performance testing on my test server? How to capture workload from production and replay on test server? Basically looking for detailed steps so that I can repro the same workload ...
0
votes
0answers
22 views

Import remote SQL Server 2008 Express database to local SQL Server 2008 Standard database

I would like to create a SQL Server agent job that would run every 10 minutes. The job would check for new records in a table on a remote database (linked server already created), if exist the job ...
0
votes
0answers
51 views

Remote scan in OpenXMl

I'm looking for some advice on OPENXML. Specifically, the performance. I am seeing very slow performance on a very small piece of XML. Something about this is causing a Remote Scan. Any ideas on how ...
1
vote
0answers
64 views

The memory usage of SQL Server keeps growing

We have a production SQL Server 2008r2 x64. 16GB RAM and this server is used by the application (hosted) and SQL Server. The max memory setting = 6GB The min memory setting = 128MB. There are ~25k ...