for SQL Server 2005, major build version 9.00.xxxx.

learn more… | top users | synonyms (2)

2
votes
1answer
306 views

Inside SQLOS – Scheduling

Using SQL Server 2012 Enterprise Edition SP1 running on Windows Server 2008 R2 SP1 For each logical processor core on SQLOS has a scheduler assigned to it. Those scheduler can be viewed as status ...
1
vote
2answers
622 views

Conditional WHERE clause

I have, from what I can tell, a unique question. I would like to know if there's a way to construct a query in which the existence of the actual where clause itself is conditional. I'm writing a ...
5
votes
1answer
1k views

How can I fix “Cannot perform a differential backup … a current database backup doesn't exist”?

We recently switched to the FULL recovery model, with full backups being done every weekend, and differentials being taken every day. The problem is, the differential backups don't always seem to ...
3
votes
3answers
141 views

Tuning reads (or perhaps the truncate!) for unusual database structure requiring regular truncates

We have an unusual database structure (I leave the reasoning for another question), that in it's current form requires a regular truncation and recreation of allot of row (about 1 million). We're ...
4
votes
2answers
331 views

Can I manually reset the “internal status flag for a full database backup”?

We recently switched to the FULL recovery model, with full backups being done every weekend, and differentials being taken every day. This worked last weekend, however this weekend the differential ...
0
votes
0answers
25 views

SQL services wont start due to incorrect drive letter [duplicate]

Possible Duplicate: SQL services wont start due to incorrect drive letter after windows restore SQL services wont start due to incorrect drive letter after windows restore Had a server ...
3
votes
2answers
1k views

Is it OK to use WITH INIT for my Transaction Log Backup to avoid having it grow too large?

I'm still struggling to understand SQL's backup jobs. We currently have a SQL Server 2005 instance using the FULL recovery model. We do a full database backup every week. BACKUP DATABASE ...
2
votes
2answers
629 views

Reset / force SQL Agent Next run date

I need to test SQL Agent over a period of time, so need to change the system clock into the future quite often (and back)... don't worry it's only my local machine not a server :-) The trouble is ...
0
votes
2answers
394 views

Is there a SQL Server equivalent to “OVERRIDING USER VALUE”

While googling I found about the OVERRIDING USER VALUE parameter for an INSERT for IBM's iSeries. Is there an equivalent command for Microsoft SQL Server versions 2005 or newer to allow you to ...
1
vote
0answers
225 views

FOR XML EXPLICIT problems in SQL Server 2005 Express

SQL Server 2005 Express Service Pack 2 w/Advanced Services Windows 2003 R2 I recently migrated a database from MSDE 2000 to MSSQL 2005 that is used for a tourist website that can be displayed in one ...
4
votes
2answers
273 views

Job fails overnight intermittently because of a windows authentication failure to log on to SQL Server. How do I troubleshoot?

The failed job is a Litespeed transaction log backup, but also happens to fulls and diffs occasionally. This same setup works on other servers without issue, and it's only a few times overnight that ...
2
votes
1answer
2k views

Remove sql server service from windows 7

I had installed and later uninstalled SQL Server 2005 . I used registry cleaner tools and deleted all files related to SQL Server . Still the services console shows entry for previous installed ...
5
votes
1answer
275 views

BCP stops after the last “1000 rows sent to SQL Server. Total sent: …”

I ran SQL Server 2005's bulk copy program BCP like this: bcp mydb.dbo.mytbl in myfile.blk -c -S mysvr -U mylogin -P mypass And it ran and produced output like so: Starting copy... 1000 rows sent ...
1
vote
1answer
139 views

SQL Server 2005 Blocking Issue

I am experiencing a blocking issue in sql server 2005. An end user executes a query (e.g. select statements) and seems to get into a never-ending blocking until i kill the process e.g. for hours on ...
0
votes
1answer
104 views

Collecting trace info of SQL Server 2005 using SQL Server 2008 R2 profiler

I have a vs2005 application that uses SQL Server 2005. I was trying to collect the SQL trace generated by the application while executing. For collecting the trace I've connected to SQL Server 2005 ...
2
votes
1answer
123 views

can you run sql server 2005 and sql server 2008 r2 in mirror mode?

Must all db servers be running the exact same version to enable mirroring without a witness server? How about with a witness server in place?
2
votes
2answers
3k views

SQL Server drop and create all users in every DB

I would like to drop and recreate every user in a database without having to manually do this for 500 users. I have this so far: USE [Maintenance] GO IF EXISTS (SELECT * FROM ...
2
votes
3answers
316 views

Performance impact of Splitting Table across files

EDIT: I think the original question (below) was not worded very well, and probably caused confusion. The basic question is: If I have a SQL Server 2005 database using a single .mdf file and I change ...
0
votes
1answer
568 views

How to split the comma separated list in the stored procedure

I am working on small module in which we pass the column name as comma-separated string to a stored procedure. In the stored procedure, we want to separate the column names out.
1
vote
3answers
9k views

Max connections SQL Server Express could have?

I have SQL Server 2005 Express edition installed on one of my client's machine, and lots of other users are also connected to that SQL Server through the C# application that I have provided them as an ...
0
votes
0answers
29 views

Max connections sql server express could have? [duplicate]

Possible Duplicate: Max connections SQL Server Express could have? I have sql server 2005 express edition installed on one of my client's machine, and lots of other users are also connected ...
8
votes
1answer
3k views

Upgrade SQL Server 2005 to SQL Server 2012

I have a test environment set up with the following: Virtual Machine (Hyper-V) Windows Server 2008 R2 SP1(x64-bit) Windows SQL Server 2005 Developer Edition SP4 (x64-bit)(default instance name) 1 ...
0
votes
1answer
185 views

SQL Server 2005 on Windows 7 along with SQL Server 2008 R2 Express edition

I've installed SQL Server 2008 R2 Express edition on my Win 7 notebook. Using since an Express edition this doesn't have SQL Server profiler enabled. Thus it's hard for me to debug my SQL Server 2005 ...
5
votes
2answers
562 views

Deleting duplicate records when using text datatype

I have a large (~678,000 rows) table storing emails, and I need to delete duplicate records that match the fields of the email: to, from, subject, body, as well as the foreign key record_id. Normally ...
0
votes
0answers
82 views

Error message installing SQL Server 2005 Enterprise on my Windows 7 Enterprise [closed]

I have a problem installing SQL Server 2005 on my Windows 7 Enterprise 32 bit operating system. The installation never completes. The error log file states I need to have IIS installed (I do and it ...
0
votes
2answers
317 views

Remote database connection problem?

I have two systems with Windows XP. I have installed SQL Server 2005 on a system and tried to use SQL Server Management Studio Express on both to use the database. I am able to use the database on ...
2
votes
1answer
813 views

what is difference between last_worker_time and last_elapsed_time in DMV sys.dm_exec_query_stats?

what is meaning of last_worker_time and last_elapsed_time in DMV sys.dm_exec_query_stats and what is differnce between them? when I fire below query SELECT TOP 20 qs.last_worker_time, ...
1
vote
2answers
324 views

Size of TempDB Microsoft SQL Server 2005

Are there drawbacks to having a large tempdb in a SQL Server database? Assuming the disk is not full. I am creating large temporary tables in a couple of queries. Once I am finished running queries, ...
2
votes
2answers
543 views

Get disk space percentage free with SQL Server 2005?

I am currently using SQL Server 2005 and (undocumented I believe) master..xp_fixeddrives to get free space on my database volumes as part of my monitoring. However, this only gives me an absolute ...
2
votes
2answers
713 views

Securely Send Database Mail via an Insert Trigger

I have spent about 30 hours so far trying to get sp_send_dbmail to work. I finally got SOMETHING to work, but I have serious doubts as to its security. I would like know a method which is better yet ...
6
votes
3answers
6k views

How can I backup a large SQL Server database without impacting performance?

We've had reports of queries running slowly or timing out early in the morning, and the only job I see running that I think could affect this is our database backup job. The database itself is about ...
0
votes
1answer
198 views

Get percentage free space on database volumes

I am currently using SQL Server 2005 and (undocumented I believe) master..xp_fixeddrives to get free space on my database volumes as part of my monitoring. However, this only gives me an absolute ...
4
votes
1answer
310 views

Why does WAITFOR (RECEIVE FROM QUEUE) show up in the monitor incorrectly?

I kick off the following command in my app: WAITFOR (RECEIVE CONVERT(int, message_body) AS Message FROM MyQueue) When I run `sp_who2 active', I get Status=SUSPENDED and Command=DELETE Note: ...
13
votes
2answers
299 views

Does firing off an indefinite WAITFOR increase the log file size?

In the last release of my app, I added a command that tells it to wait when something arrives in the Service Broker queue: WAITFOR (RECEIVE CONVERT(int, message_body) AS Message FROM MyQueue) The ...
4
votes
1answer
1k views

How to restore replication after server crash

We had two databases on one SQL Server 2005 instance with transactional replication between them (3 tables as articles). This server acted both as publisher and distributor. Then the RAID on the ...
5
votes
1answer
2k views

ETL: extracting from 200 tables - SSIS data flow or custom T-SQL?

Based on my analysis, a complete dimensional model for our data warehouse will require extraction from over 200 source tables. Some of these tables will be extracted as part of an incremental load and ...
3
votes
2answers
169 views

Select blocking issue [closed]

The database was not responding to simple select statements like select * from table I noticed in sys.dm_os_waiting_tasks that one session is blocking, blocking session was pointing to a stored ...
1
vote
0answers
133 views

SQL server Load Balancing

SQL server user access cut down from 8pm - 9am. During this period our SSIS scripts would run to load data(from Oracle/mainframe/Access) to sql, large database(s) & too much data - mortgage ...
1
vote
1answer
367 views

Defrag or Backup+Restore

I have an MDF file that was autogrown from 1MB to 40GB in 10% increment. The file is heavily fragmented now, and I want to defrag it with minimum downtime. I have a plan that I am not sure will work: ...
7
votes
1answer
785 views

SQL Server 2000 to 2008 to 2012

We are migrating from SQL Server 2000 to 2008 now. We are making lot of changes to code, scripts because there has been a lot of change since 2000 to 2008. While making these changes, What I want to ...
2
votes
1answer
120 views

Create MS SQL login for support engineer to access only vendor database

I have sql server 2005, I need to create separate database login to support engineer of my software vendor to access their own database. My only worry is deny him to take backup from our database ...
2
votes
1answer
1k views

Solve conflict between affinity mask and I/O affinity mask?

I executed this on one of our SQL Server machines: EXEC sp_configure 'show advanced options', 1 And then executed RECONFIGURE. This presented me with the following error message: The affinity ...
8
votes
2answers
1k views

Risks of changing to ARITHABORT ON

I'm working with a vendor with the arrangement that they provide the core application, and I can build my own extensions as long as I don't modify the core application. It's built in ColdFusion ...
4
votes
1answer
18k views

ODBC Data Source SQL Server Connection - Login Failed For User

I have moved my database from an SQL 2005 to a server with SQL 2008. I am now trying to create an ODBC Data Source. I am using "With SQL Server authentication using a login ID and password ...
4
votes
3answers
1k views

Logging query text without Profiler

I'm in the process of porting an old, semi-broken ASP.NET/SQL Server application to PHP/PostgreSQL. Among the torments^H^H^H^H^H^H^H^Hchallenges I'm faced with is that the reporting is done by a ...
1
vote
1answer
448 views

How can I stop SQL from validating an OPENROWSET query when its not going to be executed?

I have a problem where a stored procedure is throwing an error because it's trying to run/validate an OPENROWSET query inside it that it doesn't actually have to execute. The stored procedure that ...
2
votes
2answers
259 views

Execution plan flips Filter and Execute Scalar when using the PK, causes cast to fail

I have some data tables that where imported in from a flat file source so everything is varchar(max) except FileRecordID which is a int that hold the row number the data came from in the flat file ...
1
vote
3answers
175 views

Check of SQL Server upgrade success

I have performed SQL Server upgrade from 2005 to SQL Server 2008. Is there any tools/possibilities to check, whether the upgrade from SQL Server 2005 to SQL Server 2008 has been accomplished ...
4
votes
2answers
121 views

SQL Server update and database transfer

In my test network there is a database created with SQL Server 2005. I have to update SQL Server 2005 to SQL Server 2008. The data base should be used with SQL Server 2008. So it is to be moved. What ...
5
votes
3answers
2k views

How can I inspect the security settings of a SQL Server Endpoint?

I am in the process of creating a TEST environment for our SQL Server development staff. In production we have 3 SQL Servers, SQL01 contains several databases that are mirrored to SQL02. SQL03 ...