-
- SQL Agent starts to fail jobs for no reason
by redwood739
- 14 Replies
- Last post
by Geert Feys
- OK, so this just happened again. All of the sudden all my jobs under the SQL agent started to fail. Just out of the blue. This happened earlier this month 7/6/2007 (today is 07/29/07). The first time I rebooted the servers since it was due anyways and it fixed the problem. This time I just restarted the SQL agent, and it fixed the problem. The two jobs that run the most often failed first (of cou
-
- datalength doubling values
by kettch
- 3 Replies
- Last post
by kettch
- Am I missing something I'm trying to return the size of the data contained in a varbinary(max) column, however it appears that the value being returned is double what it should be. Is this normal, or is there something else I need to do
Thanks,
Devin
Edit: I'm not discounting that my data may be weird, but I wanted to cast my net as wide as possible.
-
- Excel transformation adding single quote to beginning of strings
by Fran M.
- 1 Replies
- Last post
by Bob Bojanic - MSFT
- I have a ssis package created in VS2005 that transforms a SQL query result into an excel spreadsheet. The DataFlow uses a DataReaderSource to query the data and an ExcelDestination to transform the data. The problem is that in the resulting spreadsheet any columns containing string data have a single quote inserted in front of the data. So a string like [My data] becomes ['My data]. When I preview
-
- Stuck between "Failed to generate user instance" and "An attempt to attach...failed"
by Christopher Bernholt
- 14 Replies
- Last post
by LanceDelano
- I wrote an application using Visual Studio 2005 beta 2 which uses a SQL Express .mdf file, included in the project, for the database. After installing Visual Studio 2005 RC and the SQL Express that comes with it (I followed all of the uninstall instructions first) I can no longer add a SQL Express database to any of my projects, nor can I open the SQL Express database in my original project.
-
- Help, fairly complicated file parsing issue
by sadie519590
- 7 Replies
- Last post
by Bob Bojanic - MSFT
- Hi,
I have a situation where I'm having to extract key data from a financial file. Problem is, the columns are not nice and tidy.
Basically the file looks like this:
row 1: "788","Company","OPENING BALANCE:", 2084587.76 row 2: "313947","04/01/07","3","CS","FF", 170.00,"AZT","XYC I
-
- Snapshot files obsolete?
by Nick Connor
- 7 Replies
- Last post
by Nick Connor
- I recently had a problem with one of my publications that I haven't been able to figure out. Hopefully someone can help me with it.
I got this error last week: You must rerun snapshot because current snapshot files are obsolete . I assume this means the subscription needed to be re-initialized. Is this correct
If so, I don't understand why. The publication was not changed. The subs
-
- error in ssis package!
by swan_sgp
- 3 Replies
- Last post
by Jamie Thomson
- Hi,
[OLE DB Destination [1146]] Error: An OLE DB error has occurred. Error code: 0x80040E23. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E23 Description: "Cursor operation conflict".
[DTS.Pipeline] Error: The ProcessInput method on component "OLE DB Destination" (1146) failed with error code 0xC0202009. T
-
- Execute SQL Task !!! Urgent help needed
by Manuv
- 11 Replies
- Last post
by Manuv
- Hi pals, I need small help. I have a execute SQL task in which i have a delete statement with global params. delete from <tname> where (strval= ) and (year= ) both are varchar type variables. my strval column gets a value something like "DecData1.0". But when i ran my DTS package it is ignoring this SQL statement. Might because of the special char '.' in "DecData1.0"
-
- ODBC support
by achalk
- 8 Replies
- Last post
by William Vaughn
- Can CE be called from an app. that makes ODBC calls
Thanks.
-
- renistall virtual minimun memory . uncdms.dll
by joseph williams
- 1 Replies
- Last post
by Ilya Tumanov
-
- Sorry A bit Of A N00B Question on sql syntax
by Lee Robinson 2007
- 11 Replies
- Last post
by Arnie Rowland
- Ive got a SQL database binded to my Visual studio studio 2005 proect i am creating
within this database i have the following table's
Employee: which contains instances of employer's
Manager: which contains instances of the managers
Till:- containst instances of til's
i want to write a query that selects certian elements from the till table, i thought it would have go
-
- SSRS page break
by D Risher
- 10 Replies
- Last post
by D Risher
- I must be missing a check box somewhere........ I simply added a group to a report and need to do a "Page Break Before" each group. I found the check box to do that, and the report works as expected, BUT I get a blank fist page. So how do I prevent a "page break" on the "first time through"
-
- Number of Reads in Profiler
by Babu P P
- 4 Replies
- Last post
by Madhu K Nair
- Hi,
Can any of can explain, what the "Reads" column in Profiler exactly mean I'm not comfortable with the explanation given in BOL.
"The number of read operations on the logical disk that are performed by the server on behalf of the event. These read operations include all reads from tables and buffers during the statement's execution"
For the same procedu
-
- KPI
by Mark Frank
- 2 Replies
- Last post
by Mark Frank
- Hi all,
I've created a KPI and it is working correctly, however, I don't see it in the cube browser under the measures group Where can I set the property to have it appear
Thanks,
Mark
-
- What is wrong with my codes to connect VB.net to sql server 2005 Express database?
by Curious Person
- 8 Replies
- Last post
by Curious Person
- Hi am very new with VB.net (Visual Studio 2005) and the first time try to use the sql server 2005 express. I did create a trial.mdf (local server) and complete procedure to attach the trial1.mdf in Microsoft SQL Management Studio Express.
I try to use VB to connect /open/close it with the following codes: (but failed)
-----------------------------------------------
Imports System.Data.Sql
-
- DB2 lookup with parameters
by fleo
- 10 Replies
- Last post
by Rafael Salas
- Hi,
We have a package using a lookup query on DB2 to validate data from a file. Everything works fine, except for the lookup query that has to cache about 1,5 million rows.
Now I would like to specify parameters to that query to minimize the data being cached. I tried using parameters in the query, but I get an error:
"Provider cannot derive parameter information and SetParameter
-
- System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' fai
by shankah
- 1 Replies
- Last post
by nielsb
- Hi,
I am currently working on SQL server reporting. I have created custom assemblies. I am loading the custom assebly in the rdl file.
I am getting following exception
An error occurred while executing OnInit: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. (rsError
-
- Flatfile Destination Variable Filename
by iortizvictory
- 4 Replies
- Last post
by iortizvictory
- Why does the raw file have an option for a variable path and the flat file destination does not Not having this feature makes it impossible to work with variable environments. Please add this option to the Flatfile Destination.
-
- problem on importing datas from .csv file to sql 2005 database using DTS
by raviraj danasekaran
- 1 Replies
- Last post
by Euan Garden
- Hello,
I'm running into an issue on importing datas from a .csv file to sql 2005 database. All my datas has been imported successfully but the datas with doublequotes(") are imported along with additional double quotes. For example, a cell has the data, iron rod - 34" and this has been imported as "iron rod - 34"""
Can anyone please help me to co
-
- Query for Distinct Parameter with newest Date
by SW Sam
- 5 Replies
- Last post
by SW Sam
- I am having trouble setting up a query for my inspection test results for a given work piece.
Example Table [Inspection Data]
JOB SERIAL PARAM MIN MAX VALUE PF DATETIME
1 1 Test1 0 10 11 F 6/3/2007
1 1 Test1 0 10 5 P 6/4/2007
1 1 Test2
-
- chart x-axis y-axis
by zdux0012
- 1 Replies
- Last post
by zdux0012
- I'm trying to convert an old chart to Reporting Services. We have used the same dataset for years, it is very very simple. But it seems to me that Reporting Services can't deal with this simple dataset. My question is: How can I get create a line chart using this dataset. The data set consists of 1 row with 96 columns (a day divided into 96 sets of 15 minutes). Each column records how many event
-
- Is this end of T SQL / SQL ?
by M A Srinivas
- 9 Replies
- Last post
by M. Rys [MSFT]
- With LINQ becoming the language for developement in SQL Server 2008 ,
is Microsoft going to gradually come out of SQL .
Any enhancements to T-SQL in Katami
Thanks
-
- Analyze / Data Mining Ribbons
by Sutha
- 11 Replies
- Last post
by BrianJ01
- I have installed SP2 on my laptop and I have installed the latest Data Mining Add-Ins.
When I open the sample spreadsheet and select the table in a worksheet called "Table Analysis Tools Sample", I dont get Analyze ribbon under Table Tools. Is ther any reson for it
I dont get Data Mining option either! Is there something I have to do before getting those menus to appe
-
- SQL Server 2005 pass-through query failure to Oracle 10g
by jkv10
- 0 Replies
- Last post
by jkv10
- Hi all--Given a SQL Server 2005 SP2 instance and an Oracle 10g (10.2.0.3) on an AIX instance, I'm trying to write a pass-through query which will return all the contents of the following two system views:
dba_audit_session
dba_audit_trail
In Oracle, the dba_audit_session view looks like this:
Field Data type Nulls
os_userna
-
- SP to search on any number of characters
by nbk5533
- 4 Replies
- Last post
by nbk5533
- I would like to know if someone would know how to write a Stored Procedure (using Select statement) to search on a partial word, for instance, like "micro", for Microsoft Office, Microsoft Communicator, etc. or an ordered number of characters, that are unique, like "obe", and will retrieve, ad"obe" or adobe.
I'm using SQL 2005 and I'm running the search against