120 Miles

Madison, WI

nay

Thanks for responding!

I ended up running process monitor on the server while the package was executed and found that it was in fact a DLL in the oracle folder...

You are correct. It should be dbo not db_owner. I'll update my earlier post.

Thanks!

If you want to read data...

Found this: http://sql-server-performance.com/Community/forums/p/27683/149404.aspx

declare @start datetime, @end datetime, @duration varchar(36),

@hours varchar(30), @minutes varchar(2), @seconds varchar(30)

set @start = '4/29/2011 11:23:44 AM'

set @end = '4/29/2011 1:27:31 PM'

set @seconds = abs(datediff(second, @start,...

Do you want the stored procedure to execute after each row updated, inserted, deleted or after each transaction? Example: If a user inserts 10 rows in a transaction do you...

Would the sp_helpfile stored procedure be what you're looking for?

Try this out:

http://msdn.microsoft.com/en-us/library/aa337083.aspx

I saw you have: The local SQL2005DTS group.. If they are on SQL 2005 they won't be able to connect to SSIS in SQL 2008. You would need the...

-- Create the temp table for further querying

CREATE TABLE #temp(

rec_idint IDENTITY (1, 1),

table_namevarchar(128),

nbr_of_rowsint,

data_spacedecimal(15,2),

index_spacedecimal(15,2),

total_sizedecimal(15,2),

percent_of_dbdecimal(15,12),

db_sizedecimal(15,2))

-- Get all tables, names, and sizes

EXEC sp_msforeachtable @command1="insert into #temp(nbr_of_rows, data_space, index_space) exec sp_mstablespace '?'",

@command2="update #temp set...

Were you just looking for something simple like this?

use [DatabaseName]

Go

select name from sysusers

where islogin = 1

You can go into the properties of the user and then add the table under 'Securables' and grant them Alter permissions plus you can grant them the rest of the...

I believe they would be receiving the error from the GUI because of a table option. If you go to Tools, Options, Designers, Table and Database Designers, Uncheck...

If using a 64 bit operating system you will not, otherwise you will need to restart SQL Server.

Here is one that I believe I got off of SSC

-- Create the temp table for further querying

CREATE TABLE #temp(

rec_idint IDENTITY (1, 1),

table_namevarchar(128),

nbr_of_rowsint,

data_spacedecimal(15,2),

index_spacedecimal(15,2),

total_sizedecimal(15,2),

percent_of_dbdecimal(15,12),

db_sizedecimal(15,2))

-- Get all tables, names, and sizes

EXEC sp_msforeachtable...