CREATE procedure [dbo].[usp_SelectTable]  
with execute as 'dbo'  
as  
select top 1 *  

First, excuse me if I use the wrong terminology.  I am a programmer first
and work with databases only occasionally, so I might use the wrong terms.  
Second, its my first post and hopefully it's in the right section.  With that
being said:

I have a web application that is going to use SQL 2008.  Everytime I attempt
to do anything on the table(s) I get the following message.
"Unable to get records.  The SELECT permission was denied on the object
'tablename1', database 'databasename', schema 'dbo'. The SELECT ...

Why are appearing this error when we're going to create a view in SQL Server
2005?.
"Property DefaultSchema is not available for Database ... "
Now, we've created a database role function named "A" and we've added a

I've renamed the default database of the SQL Server instance on my local
machine and am subsequently unable to connect to connect to it  - *panic*..
I've done the renaming bit from the GUI of SQL Server Management Studio and
it quite happily let me change the database name of the ...

Is there an 'easy' way to add all permissions
(select,update,delete,insert,exec) to a user a a particular table on all
objects.  For example let's use the table name 'pec' and the sql user name is
'freddie'.

i have a requirement to configure bitlocker (server 2008 x64 sp1) on Sql
server standard 2008.
im looking around the net abnd cant really find much. in my experience this
usually means that:

I'm new to SQL 2008 but have been reading about a new feature where policies
can be defined and enabled.
Is there a way within this feature to check pre-existing login passwords to
determine if they meet the password complexity test of the O/S? I know when

Hello, is it better security practice to install sql server 2005 as
regular/minimum permission user and not the machine and/or domain
administrator account?  Thanks in advance.

I have configured Broker Service on my Dev Server. While Running this
I am getting the following Error Message in SQL Server Error Log.
Please help me how to resolve this?
"The activated proc running on queue Gateway.dbo.LogFileRecQueue

I have 2 DB, with the same owner.
In the first DB, I have a table with dbo as schema.
In the second DB, I have a view that read the table of the first DB and
also using dbo as schema.

This is an "after the fact" question, i.e. we no longer have the issue, but
don't know what happened.
- A SQL upgrade script from a vendor was ran on a user database.
- The script failed.

I am not very familiar with SQL so I am hoping someone can give me a bit of
guidance.
We will shortly have a number of clients connecting to a new SQL server
across the Internet (publishing the port via one of our public IP addresses).

I'm building a tool that sends complex SQL queries to Sql Server
2000/2005/2008. These queries represent significant Intellectual Property for
the company I work for and I would like to find a way to hide the SQL query
from being displayed in Enterprise Manager's "Process Info" ...

Got a knotty problem here that I'm frankly at a loss to solve.
My organization runs a document processing suite of programs known as
Teleforms. The setup uses a client computer running the actual
scanning/verifying applications that is connected to a server, where