If shrink is currently running, you will just have to wait for it to finish. Adding more files is not going to help if you have an ongoing shrink operation.

Ankit Bhurat (7/22/2008)

---

I was just wodering if there is some DB which I can attach and do something like:

SELECT * FROM [TableName] where Database = 'ReportDB' and Userid = 'John'...

Fix the code's a popular option.

Post the code please, the table structures and the index definitions. Talking about performance in the abstract isn't very useful.

As for what queries are run, that will have to be profiler or a server-side trace.

Do what?

Can java cache a call to a udf? If so, then you can convert one of those queries into a udf with the two parameters and do a select *...

Or, if you prefer (assuming no parameters)

CREATE VIEW IsRowThere AS

SELECT CASE WHEN Row_Count >0 THEN 'True' ELSE 'False' END As ItsThere

FROM

(SELECT COUNT(*) AS row_Count FROM Sometable Where SomeConditions) x

GO

Can't java call stored procedures?

Try killing the data import. Is it blocked by the shrink? If so, the shrink will finish and then the import can continue.

You are going to switch the autoshrink off?

exec sp_who2

or

select * from sysprocesses

CrazyMan (7/22/2008)

---

Hi Gila

I found a work around, but iam facing error, the work around is

select * from OpenRowset...

Please ask your...

Not possible. A view is a single select statement.

Could you explain a bit more why you're trying to do this?

What rights does Domain name\DC login have on the machine running SQl server? Is it local admin?

Have a look in the error log (it's just a text file if you...

No it won't. dbo is not a server-level principal. It's a database-level principal.

Did you ask him about impersonating a sysadmin?

whenever i m trying 2 execute the xp_fileexist proc by mentioning...