create table (

[COLUMN] int not null

constraint [PRIMARY_KEY] primary key ([COLUMN])

)

You can use the output from one of these commands.

exec sp_helprotect

select * from sys.database_permissions

select * from sys.fn_builtin_permissions(DEFAULT)

It can be done by creating stored procedures that show you the security settings, and granting you access to execute those stored procedures.

Lee Forst (1/7/2008)

---

Thanks for your reply Roy. Albeit, not helpful. We have a small DBA shop that is overworked that is supporting a huge migration to 2005. ...

It has nothing to do with installing...

When you want to pass character date strings to SQL Server, the best format to use is YYYYMMDD, example: 20080131.

This format is always interpreted the same by SQL Server, not...

That is just the default Windows Server setting.

You should change it for any SQL Server installation.

exec master..sp_MSForeachdb

'

-- exit if system database

if ''?'' in (''master'',''model'',''msdb'',''tempdb'') return

use ?

print ''Database = ''+db_name()

exec sp_Reindexing

'

Just create an account for them to use and insist they use it. Better yet, insist that they use a Windows account for their maintenance.

Don’t bother trying to talk...

Terri (1/3/2008)

---

And my calculator says it is an...

Sanjay Pandey (1/2/2008)

---

Friends, please analyse the above one also in comparision to datediff. I use it always...

This is probably the easiest way to do it:

select dateadd(day,datediff(day,0,'2007-12-30 09:36:09.890'),0)

Probably the easiest way to fix it would be to load the data into tables with columns of type datetime.

GilaMonster (1/2/2008)

---

For the beginning and end of the day, week, month, quarter, year...

http://sqlinthewild.co.za/index.php/2007/11/05/datetime-manipulation/%5B/url%5D

I've done the end of the intervals at 3ms before the beginning of the next (ie, end of...

This query should do what you want.

selecttop 1

LastEventID = e.EventID

from

tbl_eventlog e

where

e.object_id = @object_id

order by

e.EventDateTime desc