And the query, the table schemas and index definitions please.

If it's a desktop at home, local system's fine.

It's not recommended for use in production systems because it has too many privileges and has no access to other machines.

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic619044-146-1.aspx

timothyawiseman (12/13/2008)

---

I also indexed the group by column before initially posting, and it definitely helps, but I was wondering if there was something that could specifically aid with counts, since...

I would very, very strongly recommend that you do not do that. A server with the...

What's the error?

For the full error, go to the job step properties, to the advanced tab and enter a file name for the job output. Full error will be in...

You can query sys.dm_exec_sql_text and pass it a sql_handle (which you can get from sys.dm_exec_requests and several other DMVs)

It's not exactly the same output as inputbuffer. Inputbuffer will show the...

RESTORE DATABASE ... FROM ...

See books Online for the full details. Or, from Object Explorer, right click the databases folder...

Try attaching them. It should work.

From object explorer, right click the database folder and select Attach Database

ALTER TRIGGER [dbo].[trTest]

ON [dbo].[NotesF_Devices]

AFTER UPDATE

AS

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT...

I used...

That's a bit of a vague question.

How would the process of querying the table with ref to this column work after encryption?...

Hehehe :hehe: You only just noticed?

In the first statement, both of those numbers are integers. When SQL does maths on two integers, the result will be an int. In this case, the result is too...

There's often more than one entry in that view. Try the following and see if there's more than one entry and, if so, if one of them has a uow

select...