Barry,

That's interesting. I might give that a try.

Sounds like you're moving in a good direction. Good luck, and remember that you should feel good you're doing the best you can with what you have. Don't let it...

People on this forum provide help for free. We don't do consultancy or design. That's what a consultant if for. You pay for their expertise, and they provide you information....

print @p_cob1 in the procedure without the IF/ELSE. I wonder if it's not quite what you think, some other syntax issue.

Paul,

I am a fairly light editor. I try to let you keep your voice, where a lot of editors beat it down into prose that's more academic and standard.

I can't...

Correct, some roles do not need a database user. They will typically be mapped to some user, like guest or dbo. A sysadmin will map to dbo.

I use reverse chronology so that I see the changes first when I'm looking. Over time when there are lots of changes, it's easy to get a little lost at...

I've almost always created a user in AD/Windows with no rights, assigned this user as the anon account in IIS. Then I can use it to run a DAL or...

Some good advice given, and sorry you're in a tough situation.

My advice would be this: change your attitude while you're there. Don't try to be a perfectionist, don't try to...

We can't know if there's a lock. You can check for blocking, as noted above, but what application is it? I might suggest you contact the vendor for that application.

You don't downgrade the server. The license has downgrade rights. You just install a SQL Server 2005 instance from the SS2K5 media

A login allows you access to the server. A user allows you to access a database. The link between these is what gives you access to the data (and permissions...

Likely you have an implicit conversion occurring somewhere. If you change to

month( dt_begin ) = month( getdate))

and day (dt_begin) = month(getdate())

and year( dr_begin) = year( getdate())

does that...

There are multiple reasons, but often it's a different execution plan than you expect, and that can be because of statistics being out of date. I usually look to check...

There's 2 things here. One is reformatting, one is documenting.

For reformatting, I'd get a tool. You'll waste the cost of the tool easy in doing this by hand. Red Gate...