Tagged Questions
7
votes
0answers
85 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
322 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 ...
3
votes
0answers
38 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
98 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
151 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 ...
2
votes
0answers
44 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
103 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
151 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
121 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
102 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
65 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
245 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
208 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
139 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
204 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 ...
