Hi,

Keeping QA in sync with Production may help the testers but becomes a problem for dba's. We had a daily job to restore prod backups on QA for the same...

George,

Glad I could help 🙂 I think only admin/moderator can close this topic.

BR,

avm

Hi George,

Do you have SQL Server Management Studio Express installed on the computer? If yes, then log back in as the other user, open management studio, connect to the database,...

You will need to explicitly cast the variable as (n)varchar(max)

for example

declare @STR varchar(max)

select @STR = replicate('a', 9001)

select len(@str) --returns 8000

select @STR = replicate(cast('a' as...

In one of my past projects, I worked in a database team of 7 developers and we would compete with each other to come up with a solution. This usually...

Well, it's not much easier, if at all. And it certainly is not nearly as good, because AppRoles make it possible to easily combine accessibility checks for both the...

Alvin Ramard (8/19/2008)

---

avamin (8/19/2008)

---

rbarry: To clarify, I suggested creating a single windows user that only the app will use to talk to database. Sorry if my earlier post was not...

rbarry: To clarify, I suggested creating a single windows user that only the app will use to talk to database. Sorry if my earlier post was not clear.

I haven't used approles so cannot give you any info on that

But to ensure users can access database only through the app, you can limit the permissions of the user...

CREATE TABLE #test(

[name] varchar(100),

rows int,

reserved varchar(100),

...

you can create composite primary keys such as

EmployeeMaster - CompanyID, EmployeeMasterID

PayCode - CompanyID, PayCodeID

EarningsMiscWrk - CompanyID, EmployeeMasterID, PayCodeID

Foriegn keys can be created on this table on

CompanyID, PayCodeId refer...