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...

I've had this in my powershell library for a long time; i use this powershell script to export everything out via SMO as individual files

http://www.sqlservercentral.com/Forums/Topic1240480-1351-1.aspx

the Redgate GUI has a wizard does a decent job of allowing you create SQL Jobs to regularly schedule the Full / Diff / Log backups , all based on...