-
- Permission problems with sp_attach_db during installation
by PapaLorax
- 9 Replies
- Last post
by Vidhya Sagar
- I successfully install SQL Express silently.
Then I try the following
-S .\INSTANCE -Q "sp_attach_db 'ATTACH_AS_NAME', 'C:\Program Files\APP_NAME\SQLData\APP_DB.MDF'"
This works...sometimes. But Many times I wll get a permissions error on the folder "C:\Program Files\APP_NAME". If I go and give "Everyone" "Full Permission" to the folder.
-
- How do i find all subscriptions
by Dietz
- 9 Replies
- Last post
by Lukasz Pawlowski -- MS
- Hi There
I need to get rid of all subscriptions (including cleaning up all associated sql jobs) for RS 2000 and 2005.
We have hundreds of reports , going through them 1 by 1 is not an option.
When i look at the system tables, i join Subscription to Catalog, but i find reports with subscriptions in the system tables but when i go to Report Manger there is no subscription for the report.
-
- Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).
by marie_ceb
- 2 Replies
- Last post
by Madhu K Nair
- I have created a delete trigger in Table1 and Table2. Once I delete a certain record in Table1 it will also delete that record in Table2 or vice versa. But once i delete certain record either in Table1 or Table2 it will create an error "Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).". Can you help me on this
-
- Adding implied decimal without a derived column from Flat file datasource
by Jmandawg
- 10 Replies
- Last post
by Jamie Thomson
- We are importing Flat file data from our Mainframe system. We have a lot of money amounts coming in, but the mainframe does not store the decimals in the flat file. So for example a row in the file might look like this: +0000007894-0000000563 Where the first value is $78.94 and the second value is -$5.63 Is there anyway to have the Flat file connection manager put in the decimal place for me, or d
-
- How to stop running DTS package if my view return zero record?
by Kelvin Y
- 9 Replies
- Last post
by Phil Brammer
- Hi everyone,
I've created a DTS package runs on every day and night, but now my boss was asking if I can insert an exception code to check the view file.
So.. I need help from you guys, cause I don't know How.
This is my DTS description.
My DB will generate a view called "Calls to Add", then it will run the Transform Data Task and insert into a txt file. once it finished, it
-
- Looping through XML
by shax
- 3 Replies
- Last post
by Kent Waldrop JL07
- Using the following XML string passed to a stored procedure <Customer CustomerID='ALFKI'> <Order OrderDate='1/1/1972' Freight='3'> <Detail ProductID='1' Price='4' Quantity='10' Discount='0'/> <Detail ProductID='2' Price='5' Quantity='2' Discount='0'/> </Order> </Customer> I can use the following Transact SQL to add the order and details.
-
- External Image Appears Broken when using Interactive Sort
by Picachone
- 1 Replies
- Last post
by Picachone
- We have a logo image in our report that is an external image that references a url similiar to: http://www.myserver.com/images/logo.gif .
In the same report we have a table with interactive sorting set on several column headings.
When we initially view the report the external logo image appears perfectly and the data in the table looks fine.
If we click on a column headin
-
- Finding the nth row that breaks a threshold
by vakman
- 2 Replies
- Last post
by ManiD
- Say I have a table that keeps track of the employees my business hires, including the date they are hired and the salaries they are paid. What I'm trying to do is write a query that will tell me which employee it was I hired that took the total amount of money I pay in salaries over a certain threshold.
E.g. my threshold is $100,000 for salaries, I hire Employee A and pay him/her $50,000; a
-
- problem in reading the mirrored databse
by sigme
- 1 Replies
- Last post
by Peter Byrne MSFT
- hello all I am unable to read the mirrored database as it is always in the restoring state. I have used only two servers (principal and mirror no witness server) I tried to create the snapshot of the mirrored database but i get the following errors:
Code Snippet
Msg 1823, Level 16, State 2, Line 1 A database snapshot cannot be created because it failed to start. Msg 5119, Level 16, Sta
-
- Copy files after backup in maintenance plan
by MartyS
- 6 Replies
- Last post
by mxkieran
- Hello,
We're new users of SQL Server 2005. I created two maintenance plans...one to backup the database at 2 AM daily and one to back up transaction logs every 30 minutes. These maintenance plans write to a local disk. What we want to do, within the maintenance plan, is copy the files as soon as they are written to a remote server. Is that possible
Thanks in advance.
-
- SSRS - Chart Mouse Over
by NR_TX
- 1 Replies
- Last post
by GregSQL
- I want to do 2 things with the SSRS line chart.
1. Display the data with a "." (dot) w/o the actual value on the graph
2. Diplay the (x, y coodinates) when the user mouses over the point.
Please let me know if this can be done.
Thanks in advance.
Regards
-
- Group By
by FM78
- 4 Replies
- Last post
by FM78
- Hi
I am having problems returning the necessary data with my SQL query. The query below is returning me the correct data but aswell as getting the datemodified column, I need to get the value in the ID column that is associated with the max date modified.
SELECT DISTINCT max([item].[datemodified]) FROM [Item] INNER JOIN [ItemDetails] ON [Item].[ID] = [ItemDetails].[ItemID] WHERE [Ite
-
- Adding content to the report programmatically
by Chen Ying
- 3 Replies
- Last post
by kcon
- HI guys,
I want to add some customized text to the report programmatically before the report is rendered. As it has to be done for all the reports, I don't want to do it report by report.
For example, the report needs to display user selected filters.
Any thoughts
Thansk.
-
- Equivalent Stored Procedure for Wildcard search.
by Santosh Ransubhe
- 3 Replies
- Last post
by Darren Gosbell
- Hi,
I need to convert the following MDX functionality into a Stored Procedure in MSAS 2005:
SELECT { FILTER([Store Type].AllMembers, InStr([Store Type].CurrentMember.Name ,"*", 0) > 0) } ON AXIS(0) FROM [Sales]
Is it possible to use the stored procedure "Like" implemented under the Analysis Services Stored Procedure Project ( www.codeplex.com ) If yes, what would
-
- How to set port number on smtp connection manager send mail task
by M Arrabi
- 1 Replies
- Last post
by Phil Brammer
- Hello, We have an SSIS job that runs once a day and sends emails. For security reasons, IT switched the send-mail porton the smtp server from 25 to a different number (let's say 1234). So, I changed the SSIS SMTP Connection Manager's smtpServer string to smptserver:1234 However, this does not seem to be working. I keep getting 'Send Mail Failure' error. Any ideas how to set the port number for sen
-
- Poor Performance Temporarily Cured by Re-booting SQL Server
by InfoSys_MLC
- 5 Replies
- Last post
by dknapp
- Poor Performance Temporarily Cured by Re-booting SQL Server
Please can you help
SQL Server 2000.
Accessed by VB.Net 2003.
Server set up by SQL consultant (who is no longer available).
We have a regular problem, which is most noticeable when analysing data (rather than data inserts/deletions) for producing xml or csv files or reports, even though the amount of data is
-
- DTSInstall.exe not being created in bin/Deployment folder
by Mrinali
- 4 Replies
- Last post
by Michael Entin - MSFT
- When I use the deployment utility in BIDS to create SSIS package installer the DTSInstall.exe does not get created in the bin/Deployment folder.
I have all the dtsx packages and a manifest file in the deployment folder.
I am able to launch the installation wizard with the manifest file but i want to know why the DTSInstall.exe is not being created.
-
- Insert data from one server to another
by amendez
- 2 Replies
- Last post
by richbrownesq
- Hi,
I need to insert and update data from one server to another. I have been searching in the internet and I have found some articles about OPENQUERY, OPENDATASOURCE and OPENROWSET.
To use OPENDATASOURCE and OPENROWSET I have to set the Ad Hoc Remote Queries Ħ°onĦħ, in my pc this is fine because I have sql server 2005 and I just need to go to surface area configuration and set
-
- Handing over SQL Server DB to client company
by PhillipM
- 10 Replies
- Last post
by Madhu K Nair
- I would like to handover a SQL server 2005 database that I've been using for testing/development to a client for use in a production environment. Besides deleting my test records from the database and making a copy of the MDF file, do I have to handover the datase's LDF file too I guess I should also compress the database before providing a copy. Please advise of "gotchas" I should be a
-
- How Can i Create a new Custom report item? the report item is extends matrix.
by younger
- 8 Replies
- Last post
by Teo Lachev
- hi everyone
what the matrix's class name
where is the matrix's dll
Can i create a new class extends the matrix
I want to override the matrix's onpaint method.
Can i do this
why the table not have the column group
-
- Problem connecting to external SQL Server
by Leen3o
- 4 Replies
- Last post
by Leen3o
- Hi all... Very much a newbie here to setting up SQL server, and am pulling my hair out over a problem... I have a VPS running Win2003 64bit and have setup my ASP forum on it (I also have SQLExpress 2005 installed on the VPS) - I have a SQL DataBase running on an external server which my old host setup for me and the old forum has been using... Now all I want to do is for my ASP forum on my server
-
- Execute SQL Task: UDF not taking parameters
by AVNIP
- 4 Replies
- Last post
by AVNIP
- Hi,
I have an Execute SQL Task in my SSIS Package. Now, this Execute SQL Task has the following query (Connection Type is OLE DB):
Code Snippet SELECT dbo.udf_CommonDateTime_Get (GetDate(), ) As User_Datetime
I want 2 things from this Task: 1) It should take the 2nd argument to the UDF from a variable. 2) It should store the value returned by this SELECT state
-
- can i create "Package" in sql2005 like in oracle
by shimshon
- 1 Replies
- Last post
by Konstantin Kosinsky
- hi all.
can i create "Package" in sql2005 like i have in oracle, inorder to keep several s.proc's organized
how
-
- Move replicated DB to different server?
by Stefan6791
- 3 Replies
- Last post
by Jayperi
- Is it possible to move/migrate a replicated database to a different server without breaking the subscriptions etc If so, is there a guide on how to do this Many thanks for your help in advance! best regards, Stefan
-
- Converted our DTS 2000 packages to Sql Server 2005 SSIS
by Sunil576008
- 1 Replies
- Last post
by Vidhya Sagar
- We are converted our DTS 2000 packages to Sql Server 2005 SSIS. I am getting following error on my ActiveX script that got converted. I am new to SSIS and DTS. Never ever worked with ActiveX also. So any help would be appreciated. Following is the script followed by error I get:
'**********************************************************************
' Visual Basic ActiveX Script
'*******