-
- No entries in Database Mail log (sysmail_event_log)
by JFoushee
- 3 Replies
- Last post
by Satya SKJ
- Hi. I've reviewed the following webpage http://msdn2.microsoft.com/en-us/library/ms189959.aspx and didn't get the answer I was looking for. (Service Broker is running in msdb.)
Essentially, Database Mail isn't logging entries. Using the following example script:
EXEC msdb.dbo.sp_send_dbmail @recipients=N'someone@somewhere.com', @body='Message Body', @subject ='Message Subject'
I get
-
- Query Notification Error
by EdenZa
- 4 Replies
- Last post
by Remus Rusanu
- Hi All
In Work , we created a Cache component that serves a large business application, we are subscribing to almost 200 queries , the component worked quite well in the first few months of the development, but lately i am getting notification events that contain "Error" in the SqlNotificationEventArgs of the event , the "Source" value is "Client".
I hav
-
- Quorum Disk again.
by Ilde
- 1 Replies
- Last post
by Kevin Farlee
- Hi, I'm trying to install a server cluster to implement an SQL Server 2005 cluster. No other services (I think this is important). I've a dual SCSI channel Smart Array with 4 disks configured in a 400Gb RAID 5. I do not need to move different resource groups from one node to the other, I need only one group with all the resources IP, Network name, MSDTC, and SQL Server..., when a node fails, all s
-
- Cross Database Issue
by ashutosh_kendurkar
- 5 Replies
- Last post
by ashutosh_kendurkar
- Hi
I have a view which is like following
Like
DB1.View1---
Select * from Accounting,Employee
where Accounting.Emp_Id = Accounting.Emp_Id
and i am using this view in DB2.storedProcedure1, but this gives me an error when I execute this Stored procedure from VBA code. the same SP works from query analyser with same user_id and pwd
Error - Could not find databa
-
- Propagation of Changes to cube from Management Studio to BIDS
by cherriesh
- 4 Replies
- Last post
by Darren Gosbell
- Hi,
I added partition for my cube through management studio. I realized that this is not automatically propagated to my project that's why every time i process my whole project, i overwrite the partition I created. Is there a way in which my project will be updated with the latest modification i did through management studio
cherriesh
-
- BCP taking very long time.
by Titu
- 3 Replies
- Last post
by Tengiz Kharatishvili MSFT
- I have a table which has near 50million records. The .dat file created by BCP queryout is of around 51GB. I am forming the BCP queryout and BCP IN commands in a stored proc and executing the same using xp_cmdshell. I am using the below BCP options : / T / b60000000 / a16384 / w / t}@ !{ / r} ^ #{\n / h"TABLOCK"
With above the QueryOut is taking around 8 hrs and BCP IN another 1
-
- Attach database - error 602
by Seppe001
- 5 Replies
- Last post
by Satya SKJ
- Hello, After re-installation of MS SQL Server 2000 (Developer edition), I wanted to attch I previously available instances in the Enterprise Manager. But, when I select "Attach database", I get the error: Error 602: Could not find row in sysindexes for database ID 9, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes. When I run this "DBCC CHECKTABLE", I get the messa
-
- Can we extract adjectives using SQL server 2005 text mining?
by jliu685
- 1 Replies
- Last post
by Bogdan Crivat
-
- MDX Sum distinct across specific dimensions
by Clayton DuVall
- 4 Replies
- Last post
by Clayton DuVall
- I have a measure group that has a few measures that are not addittive across all dimensions. I need to be able to get the sum distinct across specific dimensions and am having problems getting it to work. I tried specifying that the aggregate function should be semiaddittive, but it complains that it is missing a time dimension. I have tried many variations and combinations of MDX functions inclu
-
- BEGIN STACK DUMP error in log viewer
by BiancaP
- 3 Replies
- Last post
by LuZ
- Hi
We are having problems with our application that uses SQL Server 2005 in a cluster environment. Sometimes the system stops answering and registers in the log viewer the following error:
=====================================================================
BugCheck Dump
============================
-
- recovery many databases
by ezinsi
- 3 Replies
- Last post
by Paul Randal
- Hello! I make a full backup of many databases (about 45). How can I recovery all databases at once With a script I use SQL Server 2005. Thanks ezinsi
-
- How can I quickly remove merge replication and replication object
by Marcin_W82
- 0 Replies
- Last post
by Marcin_W82
- I have MSSQL 2000. I need a script to remove quickly merge replication and replication object (tables, etc).
-
- Locking Down Windows Admins
by CraneDBA
- 5 Replies
- Last post
by CraneDBA
- We have some Windows admins that curently have complete access to our SQL Server 2000 and 2005 databases and are making the most of it. What I would like to do is either lock them out or at least clamp down on their permissions within the instance. They tell me that their application of system patches fails when they do not have the System Administrator Server Role. I would really like to revoke t
-
- Schema change - Snapshot replication
by Armando582596
- 5 Replies
- Last post
by Michael Hotek
- How can I keep schema changes in the subscriber's database when I replicate the snapshot from the publisher
I just want to move data from a remote server, but it seems that the tables are being dropped which is not good as we use the subscriber as a development box.
Please advise
-
- SQL 2005 SP2 hung
by SNSINC
- 2 Replies
- Last post
by SNSINC
- I am trying to install SP2 and it seems to have hung. The setup screen says that it had success with the setup support files and is now on the database services "in progress" it is installing windows installer file sqlrun_sql.msp and has been here for 45 minutes. Any help would be appreciated.
Thanks
Chris
-
- Dates get alphabetized when report is shown
by bmw555012
- 5 Replies
- Last post
by Shyam Sundar
- I've built a report from a cube that I have had made. After selecting a few dimensions, the columns will be showing a drill down action related to different dates. Problem is, when you preview the report, the dates get alphabetized; they don't show up in an order like dates, days should.
ex: monday, friday, thursday, tuesday, wednesday
or april, august, july, june, may
How can thi
-
- Need script help w/ dates
by sadie519590
- 4 Replies
- Last post
by sadie
- Hi,
I have a script where I retrieve the date portion of a filename into an integer variable.
The variable value looks like this: "20070815"
My question is, how can I then take this value and compare it against the current date on the server Is there any sample code that can show me how to use date functions in this way
Thanks
-
- Report server Windows server is not running
by tenchyz
- 3 Replies
- Last post
by tenchyz
- The Report Server Windows service 'ReportServer$RCREPORTSERVER' is not running. The service must be running to use Report Server. (rsReportServerServiceUnavailable
I get this error when i tried to access report manager today. What causes this to happen because this is the second time in 6 months this has happened. The first time , i restarted the server, should i go that route again Or is t
-
- Displaying images that are accessed through URL
by flwid
- 7 Replies
- Last post
by flwid
- Hi,
I have trouble displaying images that are accessed through URLs in my report. If I call the URL directly in the Browser the Image can be opened without problems. The images can be accessed with an anonymous access.
When I deploy the report or in the Preview of Visual Studio I get the following message:
[rsWarningFetchingExternalImages] Images with external URL references will not disp
-
- SSIS Package Designer performance after installing SP1
by Swoopske
- 7 Replies
- Last post
by Swoopske
- Hi,
When I installed SP1 on my SQL Server 2005, the performance of the package designer dropped enormously. I have to wait like 30 seconds after I drag-and-drop a datasource from the toolbox to the design area. Also it takes a very long time to run the very simple package. Not to mention opening some complicated package that was done before applying SP1. The package scheduled in SQL Agent went
-
- SELECT DISTINCT will always result in a static cursor
by walid kayrouz
- 7 Replies
- Last post
by Dovewing2000
- An example for my pb 1) Created a dynamic cursor :
DECLARE cursor_teste CURSOR DYNAMIC FOR Select DISTINCT name from table WHERE ID = 1 OPEN cursor_teste FETCH first FROM cursor_teste
2)The result for this cursor is for example 'teste'.
3) If now i do an update on that name with a new value 'teste1'
than if i fetch the cursor , i''ll get the old value (teste) .
any idea how to m
-
- SubQuery Representaion Issue
by JayaC
- 6 Replies
- Last post
by JayaC
- I have a master Login table, that stores the UserId and UserName. create table #Login (UserId varchar(100), UserName varchar(100) )
insert into #Login values('U1','Tom') insert into #Login values('U2','Dick') insert into #Login values('U3','Harry')
UserId UserName ---------------- U1 Tom U2 Dick U3 Harry
Notify table stores the details alongwith the UserId's. The structure of the Notify t
-
- Fuzzy lookup error when adding additional lookup columns
by Greg Ritter
- 3 Replies
- Last post
by Rafael Salas
- I'm working with an existing package that uses the fuzzy lookup transform. The package is currently working; however, I need to add some columns to the lookup columns from the reference table that is being used. It seems that I am hitting a memory threshold of some sort, as when I add 3 or 4 columns, the package works, but when I add 5 columns, the fuzzy lookup transform fails pre-execute: Pre-Exe
-
- Member Properties
by Casius211362
- 3 Replies
- Last post
by Thomas Ivarsson
- Hi
How to create a member properties in AS 2005
Regards
-
- Creating local cubes from relational sources using XMLA
by Inmon
- 7 Replies
- Last post
by Inmon
- Hi,
I have looked at Chris Webb¡¯s example in creating local cubes. I¡¯m trying to follow his instructions but I think that the syntax or the code is incorrect somehow.
Code Snippet
CREATE GLOBAL CUBE statement. FILENAME|C:\myCube.cub|DDL|
<Batch xmlns=" http://schemas.microsoft.com/analysisservices/2003/engine ">
<Create xmlns=" http://schemas.mic