I'm going to make an assumption here, an educated guess if you might. This functionality is only available in 2008 and this is the 2005 forum so you can't...

It seems to me that doing it from within the stored procedure isn't the best option. I think there are security issues with giving write access to the file...

Have you tried dynamic sql:

create procedure someprocedurename

(@dbname sysname)

as

begin

DECLARE @sql nvarchar(max)

SET @sql = N'SELECT * FROM [' + @dbname + '].INFORMATION_SCHEMA.CHECK_CONSTRAINTS'

EXEC sp_executesql @sql

end

The easiest way to do this is through management studio, right-click the database and select properties, then the permissions button.  Select the user that you want to give showplan permissions...

If you really want to get a specific answer to your question, you need to post the query plan to the thread.  That will give people some information that will...

Look up Common Table Expressions (CTE) in books online.  They give example of how you can do paging by using a CTE.  I have seen some things that say that...

Forgive me if I have misunderstood your questions, but let me try to give you the answer that I think you are looking for...

Using the CLR in Sql Server requires...

It sounds to me that the two jobs aren't synced.  If the backup is still being copied when the restore job starts, you will get this failure although I'm not...

The interesting thing about this is that as long as I have the client tools for 2000 on my machine, I can use VS2003 Enterprise Ed to script my 2005...

Ok.  So I have two people saying Scriptio.  So... I'm trying Scriptio.

Thanks

Thanks for the reply Lucky.

I see that we are still able to script the database and have control over what is scripted.  The problem is, that first, if you choose...

EXEC sp_changeobjectowner [ @objname = ] 'object' , [ @newowner = ] 'owner'

(check BOL for more details).

I'm not sure how that will work with replication however.

Tim Januario

Try to execute sp_CHANGE_USERS_LOGIN 'AUTO_FIX', 'someusername' (look in BOL for more info). The problem is that the sid on the two servers are different which is a security violation...

Warna,

From what I understand, the beta has no upgrade. In fact, depending on which beta you have, you may have some difficulty uninstalling. Microsoft has provide a tool...

Regarding the rand(seed) option, something that gives you better randomization is to run the results through a reverse(rand(seed)) operation. rand(1), rand(2), rand(3) sorted asc will return results in the...