well, i can't tell what was supposed to be stored in the varbinary to obfuscate the date.

i assumed maybe i could convert it to int, and then do the #...

Raimon it looks like the issue has got to be in the data.

there's nothing in the query itself that seems to show that VAT Input refundable account 123600 and VAT...

wow that six year old article i wrote is just yucky.

this is how i read any current, live trace right now. hope this helps.

i used to actually put this into...

the suggestion to check for synonyms is solid; i did not think that was sarcastic at all; it would have been my first guess as well.

there's an excellent chance that...

isn't it just checkign the [Login] column in your table variable?

SET @QKILLsp= (SELECT DISTINCT ' KILL '+ CONVERT(VARCHAR,SPID)

FROM @BusyProcess I

WHERE EventInfo NOT LIKE ' ---BusyProcess Detection%'

AND [Login]...

i personally use ola hallengren scripts, but have heard a lot of good things about minion reindex;

both have defaults that fit your request, and the ability to modify the...

ok here's my verison featuring reverse and charindexes and substrings.

not as pretty, but another alternative:

/*--Results

(No column name)ipaddress

175.139.45.0175.139.45.127

175.139.45.0175.139.45.12

175.139.45.0175.139.45.1

10.10.10.010.10.10.100

10.10.10.010.10.10.10

10.10.10.010.10.10.1

*/

WITH MyCTE (ipaddress)

AS

(

SELECT '175.139.45.127' UNION ALL

SELECT '175.139.45.12' UNION ALL

SELECT '175.139.45.1' UNION ALL

SELECT '10.10.10.100' UNION...

well first, it's the wrong driver:'Microsoft.Jet.OLEDB.4.0' is for 32 bit, and is only good for Access 2003 and below;

anything above requires the new ACE driver, which is available in 32...

i think you need to provider more information.

it is certainly possible that two people have the same name...how do you know John Smith is the same or a different, new...

look at the report design as well; as mentioned, make sure the underlying query/proceudre is effience and tuned of course, but check this out:

i inherited a suite of reports...

implied dependancies only, i'm afraid.

you can search the ReportServer.dbo.catalog for specific strings; and ideally int eh <CommandText> of the xml itself, sicne that's the command that the datasource sues.

this is...

;WITH MyCTE([DrawDate],[Ball1],[Ball2],[Ball3],[Ball4],[Ball5],[Ball6])

AS

(

SELECT '12/16/2000',1,4,18,19,28,44 UNION ALL

SELECT '11/11/2000',1,3,5,26,29,33 UNION ALL

SELECT '10/21/2000',1,7,19,32,34,37 UNION ALL

SELECT '8/19/2000',1,11,18,22,25,28 UNION ALL

SELECT '6/24/2000',1,7,8,26,27,33 UNION ALL

SELECT '6/10/2000',1,6,24,25,45,47 UNION ALL

SELECT '4/1/2000',1,5,11,22,40,42 UNION ALL

SELECT '3/18/2000',1,7,32,35,46,47

)

SELECT BallNumber,Count(*) As Cnt FROM

(

SELECT [Ball1]...

well, start at SQL first.

do you want to test implied/inferred permissions, or just explicitly granted permissions?

sysadmin, or anyone in a db_owner roles would of course have showplan permissions in the...

i had hit this same error a while back, and converted to using a CLR to create all my attachments that i subsequently mail.

The CLR has access to any tables...

when doing a migration previously, i toggled all databases to read only before i backed them up, and left the old server accessible but readonly so they could be used...