EXEC sp_addrolemember N'db_owner', N'login_name'

Yes, you are out of luck. CLR is a new feature in 2005, it was not in 2000.

But why can't you change compatibility level ? Security issues? You want to...

Let me give you some advise: never trust overseas developers, they usually have no idea what they are doing. This is usually Oracle habit to build everything on cursors, so...

User or login ?

In case of former you can query sys.sysusers in your database and map it to existing login with sp_grantdbaccess, in case of latter you can query master.sys.syslogins;...

For the most recent service which the patient is currently enrolled in the EndDate would be null ?

In this case:

select

service,

patientno,

count(*)

where enddate is null

group by

service,

patientNo

Use join instead of subquery. I wrote this query but did not test it because I don't have your tables and data. Try to run the following query and let...

It depends on number of factors: where you are, years of experience, type of project, type of company, etc.

In New York for example 5-10 years experienced SQL Server DBA usually...

Thanks Andras, that's good. I used syscomments for years and did not know that in 2005 they added something new for it.

sql_modules is certainly better, you don't have to concatenate...

with t as

(

select

rn= row_number() over (order by col1,col2),

col1,

col2

from tst1

)

delete t

where rn not in

(

select min(rn)

from t

group by col1, col2

)

You can also use this, I think it's simplier:

select

distinct object_name(id)

from sys.syscomments

where text

Hi Andras,

I also ran this command out of curiousity and in order to preserve it for future emergencies. However it displays log record in binary format. Do you have a...

Generally speaking, it is not recommended to use undocumented procedures in your production environment. They are not supported by Microsoft and can be dropped or changed at any version.

So...

If your database is large and you want to minimize downtime you can also consider this method: bring database off-line, physically dismount hard disks with its data-files (or in case...

No, 2005. This is SQL Server 2005 forum.

Please clarify what do you mean page file ? Page size is fixed 8k size, data file size depends on your volume of data. And again, it's not clear you...