Why does every question even indirectly touching about space, result in someone saying you need to shrink the database.

coming back to the question. if the database is bigger, is it...

does the execute as account have permissions/access to that database.

list the account/user and its permissions, that is usually the best starting point

venkuforever (11/2/2009)

---

SQL Server detected a logical consistency-based I/O error: torn page (expected signature: 0x55555555; actual signature: 0x15555555). It occurred during a read of page (1:671644) in database ID 14 at...

Duplicate topic

Please reply to

http://www.sqlservercentral.com/Forums/Topic812728-145-1.aspx

Duplicate topic.

Please reply to

http://www.sqlservercentral.com/Forums/Topic812728-145-1.aspx

simple enough error, the values that you are trying to insert, have a quote inside. you need to replace the quote with two quotes. although there are other ways of...

That is the second one in two days 😀

malli.chitturi (11/2/2009)

---

Its not about memorizing the Q&A. Its about SQL is easy to Learn but hard to master. So Its just helping what part of SQL they have to concentrate...

Anyone want to join the white space debate, is less more ?

http://www.sqlservercentral.com/Forums/Topic812429-5-1.aspx

I know what 'white space' is, but how you can think it applies in this context I have no idea :crazy:

Dont really have the time for this.

the problem that I see is that, in the function the second select is referencing sys.dm_exec_sql_text, which needs master database access and also requires...

tobe_ha (11/2/2009)

---

No!

Msg 297, Level 16, State 1, Line 4

The user does not have permission to perform this action.

I had added the folliwing permissions to the login:

use master

grant view server state...

execute as LOGIN = 'xxx_admin'

select [admin].[fn_db_get_sqltext] (1)

--exec [admin].[sp_list_blocking_sessions]

revert

does this work

execute as USER = 'Admin_user'

select [admin].[fn_db_get_sqltext] (1)

--exec [admin].[sp_list_blocking_sessions]

revert

You can specify a...

Agree with Dave, lose the sub selects and use the direct value. one of a few options you could use

Are you talking about a post that you have made here, if you have added an attachment, people can open the attachment that is applied to your post.