The Cursor operations you see are coming from an API such as ODBC. The Cursor Prepare sets up the query this cursor is executing. @p1 is the Cursor...

Hi Chris,

You have asked a number of questions and I am not sure there is sufficient information to answer all of them.

If you properly define the referential integrity between...

Hi Dennis,

Perhaps I am reading too much between the lines but, as I read the original post, I don't think your approach will resolve his issue. His database is...

If the user can log on with System Administrator rights then you cannot restrict their access to data using either SQL or Windows security features.

You can try some other approaches...

Actually you can and do it very effectively IF certain conditions are met.

If you want detailed information I recommend you contact the folks at http://www.SQLRx.com. Here is...

I am not sure I understand all of the issues you face, but I can assure you that you can restore a foreign back up on a local server. ...

Hi Terry,

I don't know of anyway to do a direct MSSQL backup to a shared or mapped drive or to a UNC.

You have to do the backup to a local...

Hi Bill,

There are a whole lot of depends involved with this issue. First it depends to some extent on what technology you are using for your web app. ...

Thanks for the replies. I understand that Red Gate or Idera tools can compress the files, etc. which will reduce the time to copy but I don't have the...

Thanks.

There are many many books on this topic. It is probably the most fundamental aspect of database design and has drawn a legion of authors, opinions, hacks, heros, and...

Well,

First the simple answer. You can use the coalesce function to test a parameter and provide an aternate value if it is null.

Coalesce(@Address2, '') will yield an empty string...

The first problem is on this line

set @cmd = 'CREATE DATABASE '+@name'

You have a single quote after the identifier but you need an operator so change it to

set...

Your example makes it look like the Col1 value might be calculated as a function of EmployeeId. Is this true?

What is the data type of column "ACCT"?

Your problem may be with the comparison

ACCOUNT Where ACCT = 'D00-0219 ' and substring(ACCT,4,1) =...