Question Abt Turning On Svc Brker For Msg Delivery

Apr 4, 2008

hello,

I am trying to enable service broker by issuing this command:

USE master ;
GO
ALTER DATABASE msdb SET ENABLE_BROKER ;
GO

It is taking a while to do that and I am wondering whether msdb needs to be in single user mode? Some smaller dbs completed right away. Going through Surface area config I got a message that I need a service broker endpoint and I looked at my other db and that has dbmail functioning and same message saying this instance needs an endpoint in surface config, what do you think is wrong?

View 1 Replies


ADVERTISEMENT

SQL Reporting And Delivery

Apr 15, 2004

Is anyone else having problems with subscriptions and delivery with SQL Reporting Services? I can set up a subscription and uncheck "Include Report" and the email sends fine. When I try and "Include Report" such as a PDF I get "Failure sending mail: The Report Server has encountered a configuration error; more details in the log files" This was the default set up. I guess I am not sure as to what user/service accounts should be used. The Reporting Service and SQL are on the same machine (2003).

Thanks for ANY suggestions!!

If it helps. The Log file:

at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String renderFormat, String deviceInfo)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!notification!117c!04/15/2004-17:38:10:: Notification 6fbda5ab-c633-4e37-a168-29348fcc58e0 completed. Success: False, Status: Failure sending mail: The Report Server has encountered a configuration error; more details in the log files, DeliveryExtension: Report Server Email, Report: eBusinessRequests, Attempt 0
ReportingServicesService!dbpolling!117c!04/15/2004-17:38:10:: NotificationPolling finished processing item 6fbda5ab-c633-4e37-a168-29348fcc58e0
ReportingServicesService!library!117c!04/15/2004-17:44:46:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
ReportingServicesService!dbpolling!a60!4/15/2004-17:46:09:: EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!117c!04/15/2004-17:46:09:: EventPolling processing item 60afa787-7b2b-4a39-b61f-f52c87620ca1
ReportingServicesService!library!117c!04/15/2004-17:46:09:: Schedule bf0fc6ef-14b1-4967-b4ca-d86d49641cb6 executed at 04/15/2004 17:46:09.
ReportingServicesService!schedule!117c!04/15/2004-17:46:09:: Creating Time based subscription notification for subscription: 7c778107-5940-43b3-8b62-62630510d503
ReportingServicesService!library!117c!04/15/2004-17:46:09:: Schedule bf0fc6ef-14b1-4967-b4ca-d86d49641cb6 execution completed at 04/15/2004 17:46:09.
ReportingServicesService!dbpolling!117c!04/15/2004-17:46:09:: EventPolling finished processing item 60afa787-7b2b-4a39-b61f-f52c87620ca1
ReportingServicesService!dbpolling!a60!4/15/2004-17:46:09:: NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!117c!04/15/2004-17:46:09:: NotificationPolling processing item 23e10ae2-063e-41da-b1bf-241e7a3ec010
ReportingServicesService!emailextension!117c!04/15/2004-17:46:10:: Email successfully sent to "preisinger@ronco.net" <preisinger@ronco.net>
ReportingServicesService!notification!117c!04/15/2004-17:46:10:: Notification 23e10ae2-063e-41da-b1bf-241e7a3ec010 completed. Success: True, Status: Mail sent to preisinger@ronco.net, DeliveryExtension: Report Server Email, Report: eBusinessRequests, Attempt 0
ReportingServicesService!dbpolling!117c!04/15/2004-17:46:10:: NotificationPolling finished processing item 23e10ae2-063e-41da-b1bf-241e7a3ec010
ReportingServicesService!library!117c!04/15/2004-17:54:46:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
ReportingServicesService!library!117c!04/15/2004-18:04:46:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
ReportingServicesService!dbpolling!a60!4/15/2004-18:12:10:: EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!117c!04/15/2004-18:12:10:: EventPolling processing item 047ca2e8-cba6-426d-a444-c568507ed611
ReportingServicesService!library!117c!04/15/2004-18:12:10:: Schedule f6403b01-2257-4915-b1a7-8e956063bb53 executed at 04/15/2004 18:12:10.
ReportingServicesService!schedule!117c!04/15/2004-18:12:10:: Creating Time based subscription notification for subscription: 1e5a59b4-7ce3-4d68-93fe-46eaa3fa6265
ReportingServicesService!library!117c!04/15/2004-18:12:10:: Schedule f6403b01-2257-4915-b1a7-8e956063bb53 execution completed at 04/15/2004 18:12:10.
ReportingServicesService!dbpolling!117c!04/15/2004-18:12:10:: EventPolling finished processing item 047ca2e8-cba6-426d-a444-c568507ed611
ReportingServicesService!dbpolling!a60!4/15/2004-18:12:10:: NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!117c!04/15/2004-18:12:10:: NotificationPolling processing item 233cdee0-a477-4ae0-9af3-10871c1c7d63
ReportingServicesService!library!117c!04/15/2004-18:12:10:: i INFO: Call to RenderFirst( '/eBusinessRequests/eBusinessRequests' )
ReportingServicesService!library!117c!04/15/2004-18:12:10:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files, AuthzInitializeContextFromSid: Win32 error: 110;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files
ReportingServicesService!library!117c!04/15/2004-18:12:10:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!emailextension!117c!04/15/2004-18:12:10:: Error sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report Server has encountered a configuration error; more details in the log files ---> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files
at Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, ReportOperation rptOper)
at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyDate)
at Microsoft.ReportingServices.Library.RSService._GetReportParameters(String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
--- End of inner exception stack trace ---

View 3 Replies View Related

BCP Delivery The: ° Character

Dec 8, 2004

Using the BCP utility ->

With a degree character in the flat data file, can anyone deliver this to a table without SQL Server changing it to stacked bar: ¦



CREATE TABLE "dbo"."F_conv"
(
"col1" VARCHAR(21) NOT NULL
)
;


myformat.fmt


8.0
1
1SQLCHAR030"
"1col1""


mydata.dat file


1332 NS 4° Tall 32 oz


bcp command

bcp "MY_DB"."dbo"."F_conv" in "mydata.dat"
-q -S<server> -Usa -Psa -f"myformat.fmt"

View 3 Replies View Related

Report Delivery

Mar 27, 2007

hi all,
I have created a report using sql server 2005 RS.Ive deployed it in the server(localhost)also.In the subsription section of the report manager ive mentioned a emailid to whom ive to send the report.Ive selected the report server email delivery method from the dropdown list.After entering the emailid and scheduling the report and when i click ok i find that the report was not delivered.Im getting this error.

Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.

I culdnt find enything in the log files.

Can any1 help me as how to accomplish this?

Balaji

View 2 Replies View Related

FTP Guaranteed Delivery

May 4, 2006

Hi,



I'm new to SSIS but have been using BizTalk for a while. My question is, if the FTP task in SSIS ensures guranteed delivery of the files transferred. I know that in BTS, potnetially you can start processing incomplete files (unless you set the staging, temp folder). Can this be a problem in SSIS FTP transfer? I'll be dealing with very large files (5 gigs in some cases) transfers via FTP, on an unreliable network in my project, which means that the file can be partially transferred when the connection breaks down.

I need to know, if in SSIS

(1) FTP task supports partial transfers, and then resuming the download/ upload of these files from point of failure, when the network is again available (Regets, Reputs)?

(2) If EOF is received, before the rest of data is received, especially in the case if 1) is supported, then does FTP task believe that whole file is received or will it wait for the rest of content, before task completion?

I'll appreciate if someone can answer these and can also send me the details of FTP implementation in SSIS

Thanks,

Ali Shahzad

View 1 Replies View Related

Email Delivery

Apr 11, 2007

I'm using the web service to run reports from an application. However, I don't want to wait for a report to complete; I would like to just have the report emailed to the user when it is complete. I've only found email delivery through subscriptions. Is there another way to deliver reports via email?



If I have to use subscriptions I would like to set them to run "immediately". I've found that setting the start date to sometime in the past does not seem to run the report. Is there some way to set a schedule to run immediately. I've thought of setting the time to the near future, but I seem to have the problem of getting the proper timestamp. Can I get this through the web service some how?



Thanks,

Sam



View 1 Replies View Related

Report Delivery -- HELP

Mar 16, 2007

Is SSRS limited to delivering reports to recipients inside your domain (active directory)? I'm using an SMTP server for report delivery an have set the SendMailToUserAlias to False and still can only send reports to e-mails with my domain (user@mycompany.com). I need to send reports to recipients outside my company -- is SSRS capable? If so, how do I configure it to do so?

View 1 Replies View Related

Turning A Null Into A Value

Aug 16, 2006

I am trying to return a 0 when there is a NULL as a result, I thought that Sum(ISNULL(Payment,0) would do the trick, I was wrong...any ideas:
 MonthlyCredit =
(Select
Sum(ISNULL(Payment,0)) from transaction as t
Where AccountNumber = @AccountNumber
and
Month(t.PayDate) = @Month
)
 

View 6 Replies View Related

Turning Off The Log File

Jan 13, 1999

Is There any way to stop a database from writing to the log file when you alter the design
of a table.

View 1 Replies View Related

Turning Triggers Off

Jan 16, 2002

Is it possible to turn a trigger off in SQL Server as you would be able to do in oracle? If so, how?

Thanks
David

View 1 Replies View Related

Turning IDENTITY_INSERT ON

Aug 22, 2001

Im trying to do an INSERT SELECT statement in the following manner:

INSERT INTO
DB1.dbo.TABLE
SELECT *
FROM dbo.TABLE1
dbo.TABLE2 ON dbo.TABLE1.column = dbo.TABLE2.column

And Im given this error message:

An explicit value for the identity column in table 'DB1.dbo.TABLE' can only be specified when a column list is used and IDENTITY_INSERT is ON


So if anyone knows how to turn it on it would be a great help.

Sincerely,
Matt

View 3 Replies View Related

Turning Triggers On And Off.

Feb 15, 2005

Hi is it possible to run a certain SQL statement agaisnt SQL Server and ask it not to fire any triggers? Or is would it be better to disable the trigger and then reable it after ward? If so how? Thanks Ed

View 3 Replies View Related

Turning RDA Tracking Off

Nov 28, 2006

I have a device application that simply needs to upload data to a server. The preferred DB server is Oracle but I've made it work using RDA and SQL Server. The problem I'm having is that it just needs to upload data, whichh I send using the RDA.Push() method. The data arrives just fine, the first time. With every subsequent upload all of the previous data is deleted fromt he server. Apparently RDA is tracking the deletion of the previously uploaded data locally and on the next .Push deleting that data from the server.

My question is: Is it possible to prevent RDA from deleting data on SQL Server? I attempted to delete the rows from the __sysDeletedRows/__sysRowTrack tables but got a "Data is read only" error.







View 1 Replies View Related

Turning Age 65 Or 75 In May 2008

May 12, 2008

--Environment: SQL Server 2000
I am doing following query for who is reaching of Age 65/75 in May 2008 but Member_DOB's or Spouse_DOB's showing different month. Month should show '05' because I want to see results who is reaching of age 65/75 in May 2008 only.
Please help in this regard.
--Query:
Select m.empid, m.dob "Member_DOB",
round(datediff(dd,m.dob,'05/30/2008')/365.25,1) Member_Age,
d.dob "Spouse_DOB",
round(datediff(dd,d.dob,'05/30/2008')/365.25,1) Spouse_Age
from member m
left outer join (SELECT * FROM depend where depcode = 'S' and activestatus = 1)d
on m.empid = d.empid
where (datepart(yy,m.dob) in (1933,1943) or
datepart(yy,d.dob) in (1933,1943))
and round(datediff(dd,m.dob,'05/30/2008')/365.25,1) in (65,75)
or round(datediff(dd,d.dob,'05/30/2008')/365.25,1) in (65,75)

--Results:
Empid Member_DOB Member_Age Spouse_DOB Spouse_Age
000000033 1931-12-07 00:00:00.000 76.500000 1933-06-16 00:00:00.000 75.000000
000000085 1933-05-23 00:00:00.000 75.000000 1938-03-10 00:00:00.000 70.200000
000000695 1933-06-10 00:00:00.000 75.000000 1934-07-08 00:00:00.000 73.900000
000000792 1931-01-15 00:00:00.000 77.400000 1933-06-05 00:00:00.000 75.000000
000002406 1933-05-27 00:00:00.000 75.000000 NULL NULL
000004149 1933-05-20 00:00:00.000 75.000000 NULL NULL


Desired results:

Member_DOB and Spouse_DOB's should show '05' i.e. 1931-05-07, 1931-05-15

View 2 Replies View Related

Turning Off Select All In SP2

Feb 26, 2007

Does anyone know if there is an easy way to turn off the "Select All" option from appearing on reports with multi-selects? I am going to have a hard time getting the development staff to update all of our reports AGAIN after making them conform to SP1.

Please let me know if there is a way before I install SP2.

Thanks.

View 8 Replies View Related

Turning Off Validation

Feb 10, 2007

I need to turn off validation and I've seen some threads saying this is not possible but my situation has a twist.

A customer needs the package to connect to different modem dialup connections to connect to different servers (they use dialup for security reasons). We have written two VB script tasks at the beginning and end of a loop, with data flows in between. Before the loop the dialup connection info is read into a recordset along with Data Source connection information. The first script uses this information to dialup and the last script hangs up the connection. The problem is the package tries to validate the data connections and the package has not dialed up yet, so it fails.

We managed to confirm it works in a test environment by putting a break in the first script, manually VPNing into the test network (to allow validation of the data flow to work), and then manually disconnecting from VPN during the break. The script dials in and pumps the data. But this won't be an option in production.

So if anyone has figured out a way to turn off validation, great. Otherwise, any ideas to make this work? I was thinking about setting up a dummy connection that would be connected outside the package before running just for validation (and then the script would disconnect to begin, but I would prefer to handle all of this within SSIS.

Any help? While I see the point of validation it's a bummer that MSFT didn't put this in the hands of the user.

Thanks, Kayda

View 4 Replies View Related

Xp_Sendmail And Delivery Receipts

May 21, 2008

I am trying to send an email out, from an SQL Server with Microsoft Office 2000 Premium (Professional also available) (could have option for Office
2003 also) installed on it (only outlook is installed, however we can change
that) It's Windows 2k3 running Microsoft SQL 2000 server SP 4.

I need to be able to, via SQL (or a stored procedure) automate sending of emails out via xp_sendmail or some other system, with delivery receipts attached to them, so that when they hit the client's server we know it. I can get it to send a delivery receipt when remoting into outlook and sending an email through outlook automatically, however it does not attach one to the ones going out with xp_sendmail. I know there's a way to do it via ASP.Net, but I'd much prefer to have a job that goes out and finds which emails need sent, and have the database server auto make the email, and sent it out on our behalf, instead of requiring someone to go in and click sends, and such via ASP.Net.

Any help will be greatly appreciated.

View 2 Replies View Related

Once Only Delivery (high Availibiltity) ?

Jul 27, 2006

Hi There

I was wondering if someone could elaborate (or provide a link) on how the once only delivery works for servcie broker.

For example you have DB1 that sends messages to DB2. DB1 has corruption at 1pm, you retore the database to 12:30pm, this will have all the messages that were in this instance at 12:30 , however between 12:30 AND 1PM several successful messages were sent. These messages are in the restored DB1 queue, they get sent again?

How does service borker ensure that these messages are not processed again. The only thing i can think of is that the inititator or target keep a complete history of messages processed. But surely this "table" would get huge and slow down servcie broker if it had to check this tale every time a message is sent or received.

I cannot find much in BOL on this topic, or maybe i cannot find the topic.

Thanx

View 1 Replies View Related

What Is The Best Solution For Delivery Of The Big Tables?

Aug 31, 2006

Hi!

Well..

I've several big tables which take part in the merge replication (web synchronization is used)

Is there any *painless* solution to delivery these tables to the subscribers?

Otherwise I've the snapshot with dozens of Mb..

Yes, the Parameterized Row Filters can be used, but sometimes it's necessary to get the whole table



Thanks

Paul

View 6 Replies View Related

Trigger A Delivery Directly

Aug 24, 2007

I have a delivery extension that prints to network printers.
Now I add a subscription like a few minutes in the future via web service for each report to print.

Is there a way I can trigger the delivery directly?

Thanks for ideas, guys.

Michael

View 3 Replies View Related

Turning A View Into A Table

Apr 15, 2007

I am in a scenario where my tables are refreshed every morning by a batch update.  I have built a few views off of one table.  To increase speed I would like to take all the rows from one of the view s and insert them into their own table.  I know this can be done with some T-SQL but I'm a noob to it and don't know how to specifically do it.Any detailed help would be greatly appreciated. -Nate 

View 1 Replies View Related

Turning SELECT Into A DELETE

May 8, 2008

I've constructed the SELECT statement to show the rows I want - and it shows 189 rows. Now I want to delete these rows. Here is the SELECT statement:

SELECT tblinqty.* FROM tblinqty LEFT JOIN tblmporder ON tblinqty.linkidsub = tblmporder.orderno WHERE tblmporder.orderno IS NULL and tblinqty.transtype = '0' and tblinqty.linkid = 'MP'

If I change the statement to "select * from tblinqty where exists ()", putting the above command inside the (), it returns over 12,000 rows! My intention is to change the SELECT into a DELETE by replacing the "select *" with a "DELETE" - but if I do that it will delete the wrong rows. How is the easiest way to turn the above successful SELECT statement, which yields 189 rows, into a DELETE statement which also deletes the same 189 rows?

I've tried changing the statement to a WHERE, thinking it would be easier to change to a DELETE, but the following yields 0 rows:

SELECT tblinqty.* FROM tblinqty WHERE tblinqty.linkidsub = tblmporder.orderno AND tblmporder.orderno IS NULL and tblinqty.transtype = '0' and tblinqty.linkid = 'MP'

View 1 Replies View Related

Turning Rows Into Columns?

May 7, 2015

I'm using SQL 2008. I want to essentially turn rows into columns. The source table has a variable number of rows and a fixed number of columns - the magical, elusive SQL query will yield a result that has a variable number of columns and fixed number of rows. A slight twist is that there is grouping by Territory, and in this example the first two rows should be reduced to one, with the SlsPerson concatenated to AA/BB.

The table, represented by RC_DataTable:

Territory----State--Est--SlsPerson
----------------------------------
Chicago------IL-----2004--AA------
Chicago------IL-----2004--BB------
New York-----NY-----1989--CC------
Los Angeles--CA-----2007--DD------

The result of the query will yield:

COL1------COL2-------COL3----------
-----------------------------------
Chicago---New York---Los Angeles---
IL--------NY---------CA------------
2004------1989-------2007----------
AA/BB-----CC---------DD------------

Here is a script to establish the above data:

USE [Northwind]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[RCDataTable](

[code]....

View 2 Replies View Related

Turning Columns Into Rows

Dec 13, 2007

I have a summary table with a number of columns that give all the information I need to build a report. What I would like to do is create a view specific to a single report, that organizes the data so that each row represents one metric. The only way I know of to do this would be with a series of Union querries, but that would require querrying what is basicly the same data multiple times. Is there some way to gather the data in one pass and then split it up with multiple Union queries? Sicne I doubt I'm explaining this well I'll just try an exsample.

Let say I have a summary table with the following columns: Location, Severity, Date_Day, Number_Dispatch, Dispatch_Duration, Dispatch_Goal, Number_Dispatch_Met_Goal, and Dispatch_Met_Goal.

Now I want to turn this into a table with the following columns: Metric, Location, Severity, Goal, Value.

The only way I know how to do that is with the following SQL:

--Number Dispatched Yesterday
SELECT Tickets Dispatched Yesterday AS Metric
, Location
, Severity
, N/A AS Goal
, sum( Number_Dispatch ) AS VALUE
FROM Summary_Table
Where

UNION
--Average Dispatch Duration
SELECT Average Dispatch Duration AS Metric
, Location
, Severity
, Dispatch_Goal AS Goal
, sum( Dispatch_Duration ) / sum( Number_Dispatch ) AS Value
FROM Summary_Table
Where...

UNION
--Percent Dispatch Duration Met Goal
SELECT Percent Dispatch Duration Met Goal AS Metric
, Location
, Severity
, Dispatch_Met_Goal AS Goal
, sum(Number_Dispatch_Met_Goal ) / sum( Number_Dispatch ) AS Value
FROM Summary_Table
Where...

Now I dont have a problem writing a statement for each metric, but it seems like this would be a rather wasteful query, as each would have the same where statement. What Id like is some way to either do all of the above in one pass (some kind of CASE statement perhaps?) or some way to pull the data for all the UNION queries in one pass.

View 4 Replies View Related

Turning DB To NON-ARCHIVE Mode

Jan 25, 2008

Hi all,

I am pretty new MS SQL server,
I am actaully working as an SAP BASIS ADMIN and 1 of our client is on MS SQL 2005 with SP1 as the DB and Win 2003 as the server.

I just wanted to know

1) How can we login to the dbase from the command prompt?

2) How to alter the database to NON-ARCHIVE mode and back to ARCHIVE MODE ?

I just wanted to execute few SAP activities for which i dont want the database to generate the archive logs, so i need some assistance.

Hoping to START GOOD here in this forum...
Thanks a million in advance to all

Waiting to hear from all the SQL gurus.

Regards
Hunky

View 5 Replies View Related

Turning Rows Into Columns

Jan 23, 2007

Say I have a table of data containing something likeRegion | County | Year | Month | Valuefor some sort of value (int). I want to re-arrange this data so that itcomes out like this:Region | County | Year | J | F | M | A | M | J | J | A | S | O | N | Dwhere the letters are obviously the months in order. How would I goabout this/what's the best way. I attempted to use 12 INNER JOINS onthe table itself, sadly that failed miserably. Also, this doesn't seemvery efficient?Before you ask I got rid of my original code (gave up!)

View 4 Replies View Related

SSIS Performance Turning

Aug 28, 2007

Hello Everyone,
Can any one update me up performance turning of SSIS and what difference would it make if I change the default value of this two parameter in each Data Flow.
DefaultBuffermaxRows
DefaultBufferSize

Also update me on what is these parameters used for.

Thank you

View 3 Replies View Related

Turning Rows Into Columns

Jan 26, 2006

I have a denormalization question that seems fairly fundamental but I haven't found the answer in BOL. I have data stored in a normalized transaction oriented database that I would like to denormalize to do some queries/analysis. Many tables contain attributes that are virtual columns driven by configuration. I am struggling with how to take those rows of data and turn them into columns of data.

Example Source:

Column1: CustomerId
Column2: AttributeType
Column3: Attribute Value

Ex Data:

123, ShoeSize, 9
123, Age, 45
123, Gender, Male


I would like to turn that into a table with one row, many columns:

CustomerId, ShoeSize, Age, Gender

123, 9, 45, Male



Also, I have other tables that are keyed off of the CustomerId that I would like to append to my ouput table via more columns. For example, a customer's address.

Example Source:
Column1: CustomerId
Column2: AddressLine1
Column3: AddressLine2
Column4: City
Column5: State
Column6: Zip


If I need to combine several tables, should I nest several merge transformations?

Thanks,

Craig

View 3 Replies View Related

SSIS - Turning Unicode OFF

May 1, 2007

All:



When creating a package, SSIS assumes varchar columns as Unicode (DT_WSTR) so before loading data into the target tables, I have to perform a data conversion from DT_WSTR to DT_STR.



Is there any way to turn UNICODE off? So I do not need to do the conversion? Please advise...



Rohan

View 4 Replies View Related

Turning Off Aggregation On A Certain Hierarchy

May 20, 2008

I have a multi dimensional cube. Among the dimensions I have, there is one dimension that has one hierarchy defined. When I view any of my measures on this hierarchy, I don't want the measures to be aggregated. I read some threads here having to do with semi additive behaviors, but Im not sure if it applies to my case. (or maybe it does and I'm just not getting it)

For example,

DimPerson

PersonID, PersonName, AnotherPersonID
1 , Person_A , null
2 , Person_B , 1
3 , Person_C , 1

The purpose of "AnotherPersonID" is to have a self join that describes a certain relationship. So, in this case, Person B and C are related to Person A. I describe this relationship using a hierarchy where A is a parent of B and C. However, I don't want the measures for Person_A to be replaced by the sum of the measures in Person_B and Person_C.

Why do I have a hierarchy if I don't want to sum the numbers? This is motivated by the need to dynamically report on A's numbers when B or C's numbers are reported. I'm just using persons as an example, but, in my case I have a bunch of members that can be paired with another member in that dimension. And when I report on a member that joins to another member in that dimension, I need to dynamically report on that member's measures as well.

Lastly, If the use of a hierarchy is not the best approach for this, would you recommend another approach?

View 4 Replies View Related

Turning The SQL Server 2005

Aug 8, 2007


Hello,
I€™m loading the Fact table of more then 8 million records. The SQL Server Database is taking hell lots of time to get this insertions and updations. Can any one guide me on turning the SQL Server 2005 Database.



Thank you

View 2 Replies View Related

SSRS 2005 E-mail Delivery

Mar 14, 2007

I have a report server set with an smtp account with Alias set to False but will not allow me to send e-mail outside the network. E-mail report delivery works fine to any e-mail with @mycompany.com but to an e-mail like @hotmail.com it gets rejected saying e-mail not recognized. I tried all config possibilities know to this man but nothing works. If long into the smtp server itself I can send e-mails outside of company. I'm thinking it may require a password from SSRS config but there is no place to put one. Any one know how to config SSRS to deliver e-mails to any and all e-mails accounts?

View 1 Replies View Related

On Demand Push Delivery For The Reports

Jun 12, 2007

I have a report which is scheduled to run every monday morning and it generates PDF and writes it to a shared location. Shared location and schedule is defined through Subscription. All this is working fine so far. Now I need to provide a facility from the webpage to execute this scheduled task on demand. So there would be a button on the website which would actually run this scheduled task and update the PDF at the shared location. How do I run this scheduled task/subscription using the vb.net code. Is there anything in ReportService2005 or ReportExecution2005 webservice? Please advise.

Thanks

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved