This tag is for SQL Server 2008, major build version 10.00.xxxx.
7
votes
0answers
98 views
SQL Server Analysis Studio naive Bayes attribute has too many states
I'm using SQL Server Analysis Studio and I'm trying to train a naive Bayes classifier. I've got an attribute called "item description" that basically represents products you can buy at a store. I've ...
5
votes
0answers
343 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 ...
4
votes
0answers
167 views
Receiving error Error: 18059, Severity: 20, State: 1 in the SQL Logs
I'm using SQL Server 2008 Sp3
Lately I'm having errors in the SQL Logs:
Error: 18059, Severity: 20, State: 1.
The connection has been dropped because the principal that opened it subsequently
...
4
votes
0answers
740 views
What would cause an orphaned ##MS_PolicyEventProcessingLogin##?
This morning I noticed my SQL Log was filling with the following message.
The activated proc '[dbo].[sp_syspolicy_events_reader]' running on queue 'msdb.dbo.syspolicy_event_queue' output the ...
3
votes
0answers
33 views
Severity 016 Backup virtual device fail
My backup on one of my servers is failing once a week. This is the alert I'm getting:
DESCRIPTION: BackupVirtualDeviceFile::PrepareToFreeze: failure on
backup device ...
3
votes
0answers
88 views
select top x works, but x+1 runs endlessly
Something happened to a table, that results in an endless executing select and I'm trying to figure out the reason.
What I tried and found out:
This runs endlessly:
select * from dbo.MyTable
As ...
3
votes
0answers
56 views
SELECT COL_NAME(969262708, ORDINAL_POSITION) returns a NULL value in one of the rows
So I've got a Stored Procedure that's copying data from one table to another. It calls this other SP to get the column names. I didn't write this darn thing, but here's that part:
ALTER PROCEDURE ...
3
votes
0answers
39 views
Error statement is not logged, only *password-— with many dashes
I use extended events to store database errors, like this:
CREATE EVENT SESSION [ErrorCapture]
ON SERVER
ADD EVENT sqlserver.error_reported
(
ACTION
(
sqlserver.client_hostname,
...
3
votes
0answers
111 views
How to replicate from SQL Server 2000 to SQL Server 2008 R2?
I have SQL Server 2000 as publisher and SQL Server 20008 R2 as subscriber.
I want to replicate data from SQL Server 2000 to SQL Server 2008 R2 on a different machine.
Primary key fields are not ...
3
votes
0answers
169 views
Why can't I read my transaction log backup file using fn_dump_dblog?
I'm using this blog on sqlskills.com as a guide to practice finding the relevant LSN in a transaction log backup for point in time recovery.
After backing up the transaction log, I attempt to read it ...
3
votes
0answers
426 views
SSIS Script to split string into columns
I have a dataset (log file) with a number of columns; one of them is "Other-Data" below (unordered string) and need to parse the string to create the derived columns according the u value (U1, U2, U3, ...
3
votes
0answers
1k views
SQL Server 2008: The database [dbName] is not accessible
I got this error from another person and I've run out of ideas. I can access this database without any problems, the database is in MULTI_USER mode, the person receiving the error is a user, etc.
The ...
3
votes
0answers
62 views
How Much Overhead Does Web Sync Add?
I am running merge replication in SQL2012 using web sync.
Has anybody done any experiments to compare the performance of web sync to connecting to replication using a straight TCP/IP connection?
...
3
votes
0answers
75 views
Security implications of guest account and database chaining on sql server?
I have another database Ydb accessing data in database Kdb. They both have the same owner.
In order to allow cross database chaining, it seems I need the guest user to be enabled in Kdb.
I did so ...
3
votes
0answers
90 views
Tools for maintaining many dev/test environments on the cloud
The company I'm currently working with is "moving to the cloud" (isn't everyone these days?)
In this case, they are moving to AWS, and they want a simple and effective way of managing multiple (SQL) ...
3
votes
0answers
688 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) - ...
3
votes
0answers
77 views
best way to consolidate data
I have three select statements which have the bulk of their columns which are the same except a few. So here is an example
select
*orgid='0'
,'P' as OrgType*
, Lang
,*cast(Null as varchar) as ...
3
votes
0answers
888 views
Event 4104, MSDTC Client 2
I have an Active/Active Sql 2008 R2 cluster that I monitor with Idera Sql Diagnostic Manager. It just started reporting that one of the instances does not have DTC or Sql Server Agent installed.
I've ...
2
votes
0answers
25 views
Cannot Delete FileStream Group from Sql Server 2008
We have migrated all our varbinary(max) column data to Azure Blob Storage and so we want to remove the old filestream columns that remain in our Sql 2008 database and the filestream filegroup but when ...
2
votes
0answers
45 views
How can I copy a user while preserving all privs?
We're changing domains. I'd like to create a new account for myself, NewDomain\Bob which has the same su-level privileges as OldDomain\Bob, to minimize the chance of disruption when IT flips the ...
2
votes
0answers
49 views
Can't get users default schema to change - SQL Server 2008
We are migrating from a SQL Server 2008 instance on a shared host to our own box. Our issue is we have a bunch of tables, procs and views that are prefaced with a schema (let's call the schema 'me') ...
2
votes
0answers
125 views
Cannot connect to SQL Server 2008 after updating the service pack
After updating, whenever I start the service of the server in configuration manager, it always stops then.
And I found the error in the log
2013-04-13 19:08:19.63 spid7s Error: 15174, ...
2
votes
0answers
54 views
How can we achive the replica of databases for SQL Server?
I have been working in VB6 to VB.NET migration project.In VB6 project they have individual databases (access db .mdb) for every user now we made that to centralized database using SQL Server.
In the ...
2
votes
0answers
193 views
Why do I get “The initial snapshot for publication is not yet available.”?
We are using Transactional Replications with updatable subscriptions. 1 publisher, 1 subscriber.
SQL Replication started encountering a constraint error on 3/6 at 10AM because people at two different ...
2
votes
0answers
134 views
SQL Server Database Hot Backups: Which Technique(s) to Use for Multi-Level Replication?
I'm reading the many other posts here about mirroring vs. replication, but I'd still appreciate it if someone with some experience would weigh in.
My small development team needs to have local ...
2
votes
0answers
49 views
Stored Procedure Performance Issue
I have a stored procedure that is stalling the database. If the stored procedure is run as a query, the results arrive nearly instantly. If the stored procedure is run as a stored procedure, with it's ...
2
votes
0answers
110 views
Last Known Successful DBCC CHECKDB
I understand that looking at DBCC PAGE is supposed to show me the last known good DBCC CHECKDB but I am not seeing this work correctly.
I have a database that I know is corrupted. If I run DBCC ...
2
votes
0answers
66 views
Configuring SQL Server Job agent
I am trying to configure the SQL Server Job Agent using the following scripts
USE [msdb]
GO
CREATE USER [mydbuser] FOR LOGIN [mydbuser]
GO
EXEC sp_addrolemember N'db_datareader', N'mydbuser'
GO
EXEC ...
2
votes
0answers
253 views
SQL Server 2008 R2 - Deadlock Trace, Need Help Understanding It
I really need help on understanding this deadlock, i've already replaced the values,
mind if anyone helps me interpreting where my deadlocks are coming from?
What does e_waitpipegetrow mean?
btw, i'm ...
2
votes
0answers
629 views
Could not continue scan with NOLOCK due to data movement SQL Server 2008 R2
I have SQL Server 2008 R2 installed on a Windows 7 laptop. I create a new database via SQL Management Studio and when I right click and select Properties, I get the following message.
Cannot show ...
2
votes
0answers
166 views
Transactional Replication Error adding new subscription (null) article
When attempting to add a new subscription to an existing Transactional publication on 2008. It is all configured on 1 server as it is for Pre-Production testing.
I get the following error when ...
2
votes
0answers
717 views
Table Lock on INSERT - How to optimize
we have a few long running procedures in the database, that cause an instant Table Lock on our main text storage table, which causes all other requests of the web app to wait (because the table is ...
2
votes
0answers
69 views
Identifying connection and publisher vs subscriber in merge replication scheme
We have an app that uses a central SQL Server 2008 database for folks here in the building on the domain. For teams out in the field - they connect to a local version of SQL Express while offline and ...
2
votes
0answers
149 views
Why is SSMS 2008 prompting me “if you are certain that you have added all the necessary full-text catalogs, click OK”
When I try to attach a database in SQL Server Management Studio 2008 (SSMS), I get prompted by this message:
If you are certain that you have added all the
necessary full-text catalogs, click OK.
...
2
votes
0answers
138 views
Auditing - parameter values not being written to log
I am using auditing to track usage of some procs in the database. In the log I can see a record for the Procedure being run and, immediately afterwards,the SQL statement that is being run. The ...
2
votes
0answers
212 views
Grant User Permission To Restore Database And Access that database in sql server?
I want to create a user having dbcreate, db restore server roles and will be db owner of that database. But there is only 1 server roles available that is dbcreator, which can create database is also ...
2
votes
0answers
578 views
Create SSIS package to copy data between SQL Server 2008 installs on different machines?
I'm new to the whole SSIS world. I'm trying to create a process to copy data between SQL Server 2008 environments. I want to be able to run a job to export data from my prod database and then use that ...
2
votes
0answers
269 views
SQL Server 2008: NULL SID for WINDOWS_USER in sys.database_principals
Has anyone ever seen anything like this before? I have a WINDOWS_LOGIN AD user that has a record in sys.server_principals with a SID and can login fine. But in a few databases, they have a record in ...
2
votes
0answers
99 views
How unsafe is it to change the data source of repl_distributor on a publisher
I have a long story that I will condense to a few bullet points that leads up to my question
Reporting Server (SQL 2008) is distributor/subscriber cluster for a SQL 2000 Transactional Publication
...
2
votes
0answers
130 views
need help finding the details of a deadlock
We are having issues with deadlocks and I am trying to isolate what database object is causing the problem.
I found Deadlock error isn't returning the deadlock SQL to be very helpful and I read ...
2
votes
0answers
149 views
SQL Server SSIS issue retrieve data when i enter into login of server side?
can any one try solve my problem here i am facing a problem Failed to retrieve data when i enter into login of server side
here is the error message
TITLE: Microsoft SQL Server Management Studio
...
2
votes
0answers
216 views
SQL Server 2008 replication scenario
First of all sorry about my english, and most importantly, my database ignorance, I'll do my best ;)
Until now, the scenario that I have is as follows:
In a server under our LAN, we have a database ...
2
votes
0answers
186 views
SSIS - Derive column values based on join/subselect from a non-table source
I have a flat file source that contains a lot of duplicate records, which have the same key fields but differ by their "changed date". I need to split this up into two outputs, one for the "latest" ...
2
votes
0answers
164 views
going from heirarchical XML to heirarchical SQL tables then SQL to c# objects to go to user view, how should I store the data in the databases?
Hi I'm getting my data from a web service using their getData call and it comes in as fairly chunky heirarchical XML, first everything all at once, like
<allData>
<product1>
...
2
votes
0answers
110 views
Change tracking on, but columns not tracking
In SQL 2008, I have change tracking turned on both on the database and table levels, with column tracking turned on at the table level. The CHANGETABLE(CHANGES...) function returns the expected ...
1
vote
0answers
78 views
Troubleshooting a SQL Server instance that won't start
I've had a problem with one instance of SQL Server 2008 (the free version) not starting automatically. I always have to right click on the icon in the task bar and start it manually. It is set to ...
1
vote
0answers
64 views
Search for multiple keywords related to separate columns on a single table
Imagine I have a table with the schema shown. Each of the columns represent a searchable collection that I would like to be picked up in the search. I am looking for a method that would derive the ...
1
vote
0answers
53 views
Is there a way to generate an execution plan for a stored procedure before executing it?
We have a very large (many millions of rows) table that contains some (few million) rows with invalid values in particular columns.
A stored procedure exists to correct the invalid records but it ...
1
vote
0answers
61 views
Job accessing linked server yields error 7391
I created a stored procedure which queries data from a linked server to insert into a local table.
I tested this stored procedure by directly executing it; it works fine.
I have to run this stored ...
1
vote
0answers
159 views
SSIS Merge Join Trouble: 3 tables into 1
So I am having trouble merging three tables into one. All sources are DB, and I am using the MERGE JOIN function. When I join my first two tables, using standard left inner join, it returns the exact ...
