ok well it is fairly easy, create a new db with this table:

CREATE TABLE [dbo].[Iops](

[Sequence] [nvarchar](4000) NULL,

[Time of Day] [nvarchar](4000) NULL,

[Process Name] [nvarchar](4000) NULL,

[PID] [nvarchar](4000) NULL,

...

Hi - I had already started an article on how to use process monitor to gather data then run a script to get the name of the table / index...

Hi,

I just had an alert from that connect item, Microsoft have confirmed it is a bug but won't fix it in this version as it isn't important enough. They...

Hi Mark,

Thanks Andrew and Sanjay.

The sysprocesses table is wrapped by sp_who* and the activity monitor but they do not give you as much detail, if you look at the definition...

it is so you can include characters in the text which would normally cause problems, i.e. in a csv you can't include a , in a field - but if...

you don't need bol.

you don't need the workstation components (I haven't installed sql on a box without the client components already installed but would be very surprised if not shocked...

Hi - these sort of things are quite difficult to diagnose without things like perfmons and network traces but:

This is a windows error that means that the server could not...

I have gone ahead and raised a bug on connect about this:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=433382

I do a similar thing in that I build a change script for numerous databases every night by comparing tfs (sourcesafe) files to databases and use the redgate sql compare...

I think it is because the second filter is an OR.

exec sp_trace_setfilter @TraceID, 11, 1, 6, N'IVR_User'

So it is saying you want any which do not match N'SQL Profiler...' OR...

Hi Vinu,

The error you are getting is a compiler error and is described in (http://support.microsoft.com/kb/185294) - but that doesn't really tell you what actually caused it.

As an exception...

What it the data you have? Is it an old backup or do you have the data files?

Hve you tried restoring / attaching them to a 2K, 2K5 or...

SQL Server uses the query engine to decide which index to use - if it is cheaper to not use the index it won't use it.

The cost is based on...

The only time I put more than one backup in a file is when I am setting up mirroring and I put in the full then transaction log backup to...

Thanks - let me know if you have any questions - ed *at* tutisdatabaseservices [dot] co [dot] uk