-
- Restoring backup from SQL2000 to SQL2005
by new sql dba
- 14 Replies
- Last post
by new sql dba
- I am restoring a backup from SQL2000 Database to 2005 and I get this error :
An exception occured while executing a Transact-SQL statement or batch
(Microsoft.SqlServer.ConnectionInfo)
Additional Information: Too many backup devices specified fro backup or restore; only 64 are allowed.
RESTORE HEADEEONLY is terminationg abnormally. (Microsoft SQL Server, Error 3205)
How do
-
- 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
-
- Is SQL Server CE really the solution?
by Stéphane Beauchem
- 14 Replies
- Last post
by Stephane Beauchemin
- Hi,
So far, with other programming platforms, I used to have the facility, embedded within application .exe, to:
1- Interface with already existing "multi-user" database (ex: Oracle, Access, etc.)
2- Create/access "local"/"Single-User" files for processing purposes. (try to minimize
-
- Dynamic File Name for Attachment
by nemotech
- 4 Replies
- Last post
by EWisdahl
- hi I am encountering the same problem above and I did exacly as described . But it is not working. I must send emails every month with dynamically named files as attachments. The files are named according to the date on which they are generated. For example on the first of November 2007, the file will be named myfile_1_11_2007. I have created a variable called DynamicFileName with package scope, d
-
- Query performance problems with join on UDF-based computed column
by Kevin Dente
- 14 Replies
- Last post
by Vlad Scherbinin
- We have a table with a couple of computed columns. The value of the computed column represents a foreign key reference into another table. We're seeing a major performance problem doing a query joining between the two tables with one of the columns, but not the other. In other words, this kind of query is very fast: select * from TheTable A, FKeyTable B where A.ComputedColumn1 = B.KeyColumn but th
-
- accessing the report server
by MarkNyats
- 2 Replies
- Last post
by MarkNyats
- i am unable to browse my report server. this is the message im getting
The Report Server Windows service 'ReportServer$SQLEXPRESS' is not running. The service must be running to use Report Server. (rsReportServerServiceUnavailable)
-
- The server principal "XYuser" is not able to access the database "Ydb" under the current security context
by tunesmith
- 5 Replies
- Last post
by Steven Gott - MS
- SQL2005 on winserver 2003. I have a view in Xdb that accesses tables in 2 different databases (Xdb and Ydb) on the same server. I have mixed mode security. I have a SQL user (XYuser) that has read access to all tables and views on both databases, yet when I try to access the view using a C# windows application I get the following error:
The server principal "XYuser" is not able to
-
- Get the max of the aggregates
by PeterZ
- 4 Replies
- Last post
by PeterZ
- Hello:
I've been researching a likely common problem with reporting services: the inability to get an aggregate of an aggregate. One particular discussion thread comes close to solving my specific problem:
http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=2021871&SiteID=1
Here's my problem. I have a table that groups data per month based on Count(). I'd like to get
-
- Throwing exception in Stored proc to catch in C# and rollback the transaction
by mohanbabud
- 5 Replies
- Last post
by mohanbabud
- Hi,
I am using sql2k5. I just wanted to throw an error from stored procedure with some message to C# to rollback my transaction. Here is how i wnated to do ( in sequence )
C# ===== Open a connection Begin the transaction
Execute the command
In the Stored Proc =========== do multiple operations one by one if error stop processing further Throw the error
C# ======== if exception
-
- Encourage use of UDFs instead of Procedures when possible?
by Kent Waldrop Fe08
- 6 Replies
- Last post
by Waldrop
- Over the past few months one of the issues that repeats in this forum has to do with the use of stored procedure output as input to other procedures. One method of dealing with this is to convert the stored procedure to a function if possible and use the function for the process.
I was wandering if it would be a good idea to change my database standards to reflect a preference to use functions
-
- Select Permission Denied on object
by sanchita
- 5 Replies
- Last post
by viraj@etech
- Hello all,
I have just begun to develop a simple web application to maintain phone book / contact details of people. I have been facing problems wrt the connection to the database, while trying to execute the reader it throws this error -
Server Error in '/phonebook' Application.
-
- Remove default parameter
by Kiranvukkadala
- 11 Replies
- Last post
by Simone
- I have a report with default parameters set as ' ' i.e a blank value through a query.
when i deploy this report RS2005 adds a <select a value> as the text listed in the dropdown beacuase of which it does not take my default value and no display of report.
How can I remove this text being shown.
Thanks,
Kiran.
-
- Error converting data type varchar to float.
by Temenos Develop
- 13 Replies
- Last post
by SQL_Menace
- Hi,
I am experencing a data type cast issue in T-SQL, basically our application comtains both numeric and non-numeric data in the same column, I want to retrieve the numeric data only.
Assuming a table has one column
create table TT(c1 varchar(20) )
and insert 2 rows into the table
insert into TT values('100')
insert into TT values('test')
Now if I want to do numeric compariso
-
- Loop throught columns of an Excel file using dtsx package!
by marina B.
- 13 Replies
- Last post
by Cim Ryan
- Hello,
I'd need an help because I'm stucked!! I have to import an Excel file into my DB. The Excel file is made by 2 worksheets but I need only one and inside this worksheet I have to loop through the columns and for each column I define a Data Flow that trasform the data as necessary and then insert into the table. I started with a "Foreach ADO.NET Schema Rowset Enumerator" with conn
-
- SubReport
by kenny125
- 1 Replies
- Last post
by kenny125
- Hi guys, I am new to Rs2005. I have created 4 seperate reports that each use their own datasource. I want to display these 4 reports as 1 big report. I want a title page followed by a summary page. The summary page must include the 4 reports within its summary, ie...report 1 on page 3, report 2 on page 5 etc..... The page numberering must also match up. Therefore page 1 is the title page and page
-
- help writing s.proc in sql2005
by shimshon
- 1 Replies
- Last post
by DaleJ
- hi all.
in my sql2005 i have a function that returns a value. func(x) returns j
how can use it in a select clause inside a s.proce
select bb, func(xx) as jj , from ....
-
- Bad DB Design
by Craigmeister68
- 4 Replies
- Last post
by Craigmeister68
- I inherited a SQL 2005 database from my bro-in law that has tables with names in the spaces and spaces and other characters in the column names. I link to these tables in an MDB file. Access 2003 sees this fine, but Access 2007 returns odbc--call failed errors. Is there anything I can do short of removing the spaces and characters ( %) from all of the table and column names Is there a switch I can
-
- SQL 2005 Analysis Service blocked by Zone alarm
by POOlmy
- 4 Replies
- Last post
by POOlmy
- SQL 2005 Analysis Service blocked by Zone alarm when trying to load new data mining structures I have given every program related to SQL rights that I can think of. If Zone Alarm is up, BI Studio will freeze up loading data mining structures. If Zone alarm shut down no issues. No logs anywhere about program being blocked. Any ideas
-
- How do I pass values to my Stored Procedure in Remote Report Mode
by Sudhakara
- 2 Replies
- Last post
by Sudhakara
- Hi, I have created an report by selecting stored procedure as dataset data source. Now when I run the report, it is asking for the parameter values for my stored procedure, but I want to pass the values from another .aspx page. Could any one please let me how do I pass values to the stored procedure parameters in the report. I tried doing the Local method of reports, but the printer icon is not ap
-
- Report from prcedure that return multiple recordsets
by Moim Hossain
- 7 Replies
- Last post
by VDeepak
- Hi there,
I am creating a report from a stored procedure that returns
multiples record sets. For an example, my stored procedure is as follows
CREATE PROCEDURE MYPROCEDURE AS
BEGIN SELECT * FROM TABLE1 SELECT * FROM TABLE2 SELECT * FROM TABLE3 END
Now lets say I want to create a report that will display the
result o
-
- Sorting parameter listbox on analysis services datasource
by Henk Gijsbert
- 4 Replies
- Last post
by SteffoS
- Hi all,
How must I change the mdx that is generated for the available values for a user parameter in order to get the content sorted
Regards,
Henk
BTW the exact mdx query is given below (and the label field of the parameter is set to 'ParameterCaption'), but I would already appreciate an example of a simple mdx.
MEMBER [Measures].[ParameterCaption] AS '[Organisatie].[Level 5
-
- opening sqlce databse in desktop application
by mukeshdokania
- 4 Replies
- Last post
by Jeff Wharton
- can we open a sqlce databse stored on desktop hard disk in desktop application
Regards
Mukesh Gupta
-
- SQL Server detected a logical consistency-based I/O error
by TJ_1
- 13 Replies
- Last post
by mrdenny
- Did anyone familiar with these errors:
SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x1a00d2fd; actual: 0x1a02d2fd). It occurred during a read of page (1:103329) in database ID 11 at offset 0x00000032742000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Server02.mdf'. Additional messages in the SQL Server error log or system event l
-
- [RESOLVED] Accessing the underlying sql query from the rdl file
by ArjayH
- 1 Replies
- Last post
by ArjayH
- Our client uses the report builder to generate reports for collection of employees. We would like to use the employee records in this report to perform some additional processing (such as the list of employees gets assigned to a particular group).
Programmatically, I can retrieve a byte stream from rs.GetReportDefinition( "\myClientEmpReport") and deserialize the stream into Repor
-
- How to add a connection manager at runtime within a script component?
by Darlove
- 5 Replies
- Last post
by Vivek Mayur Khan
- Hi all. Sorry about bothering you again but I have no choice, I'm afraid. This time I have to add a connection manager at runtime. I have a script that examines rows in a huuuuuuuuuuuuge file and it turns out that I will have to redirect different rows into 95 different text files. I would like to avoid the pain of creating the files and connection managers manually. I have a source script compone