Use this to calculate the row length in bytes (replace 'TableName' with your table name:

select sum(length) from syscolumns where id = object_id('TableName')

Greg

It's always the simple things that are the most maddening!

Greg

No, don't expect the visualization to change.  That's the "disconnected" part Disconnected Edit.  You'll have to change the properties of the destination connection and, possibly, have to recreate the transformations.

Greg

Norene,

Try putting the string variable that is executed in parens e.g.

EXECUTE (@SQLString)

Greg

Here's what I'd do. 

1. In DTS Designer, open Disconnected Edit and expand the Connections list. 

2. Click on the connection that you want to make the new...

Jason,

Are any roles members of the role that you're looking at?  I've noticed that SSMS expands the members of a role that is a member of another role while EM...

I've been using this script to prepare login and permission scripts for migrations from SQL 2000 to SQL 2005.  http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1598

Greg

Hi,

Did you try the script I posted the last time you asked about foreign keys?  It produces statements to drop and recreate the constraints.

Greg

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=387089

ALTER DATABASE is the permission that a user must have to change the maxsize and it is only available for members of the sysadmin and dbcreator fixed server roles and...

Try adding the user to db_datareader role.  Then you won't have to grant SELECT permission every time a table is created.

Greg

A member of sysadmin must grant you VIEW SERVER STATE permission for you to select from the view.

Greg

John,

Could you list the things you want a non-sysadmin to be able to do with jobs? 

Greg

Getting the list of packages is easy enough -

exec msdb.dbo.sp_enum_dtspackages

or

select distinct name from msdb.dbo.sysdtspackages

User permissions are a little trickier.  Viewing, creating, and deleting packages are done using...

Romain,

You don't get a choice in a maintenance plan.  You'd have to create your own job. 

Greg

I see what you mean.  It looks like you can't even grant other users or roles permission to execute stored procedures like sp_add_job and sp_delete_job anymore like you could in...