data privacy

RE: Determining existance of a Table in SYSOBJECTS

• by Ninja's_RGR'us

• Redgate

• Reply

Now I understand why you have so many posts Frank... You type 2-3 responses when none or 1 could do .

2005-04-04

RE: How do I delete the corresponding row?

• by Vladan

• Redgate

• Reply

Please copy the whole SQL again from my previous post, I have edited it in several places. sickid was changed to minsickid in the JOIN "ON" clause and also in the WHERE clause.If you still have problems, wait a minute till I create the tables here and some sample data, so that I can test […]

2005-03-31

RE: SHOWCONTIG Data

• by Clive-Strong

• Redgate

• Reply

Reindexing is a big issue here.  I'm new to the company and the database is a vendor supplied system.  I'm working with them at the moment. The clustered index looks good in all area's.  I reindexed the table yesterday and within 5 hours, a couple of the non clustered indexes had a scan density of around […]

2005-03-31

RE: Drill through report as Popup window

• by Joe-Piscopo

• Redgate

• Reply

Did you ever find a solution to this problem??  Please let me know.Thank you!

2005-03-24

RE: Access to Windows OS in the Enterprise for a DBA

• by Rudyx

• Redgate

• Reply

separate proc yes, conditional execution though.

2005-03-17

RE: Access via User Groups

• by Brian Kelley

• Redgate

• Reply

The group shouldn't be a SQL login. It should be a Windows login. Also, it must be a global or universal domain group. Verify the group in question isn't a local domain group. Local domain groups are not accessible outside of the domain.

2005-03-16

RE: Assigning a value to a variable, SET or SELECT ?

• by Mike_Lawrence

• Brent Ozar Unlimited Blog

• Reply

That is helpful.  I had a client claim that they needed to use a SELECT to set a value within a stored proc, or was it a user defined function?  Anyway, I was curious if the rules did vary at all depending upon where the variable value setting was being done.  Thanks!

2005-03-09

RE: Identity and Primary Keys

• by Jeff Moden

• SQLServerCentral.com

• Reply

Concur... a world of hurt lays ahead for those using Unique Identifiers in a casual manner.... and, I agree, the customer code is the unique number to be used as the primary key and you shouldn't even need an ID column. 

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2005-02-28

RE: Changing SQL Server Service Accounts - Problem with xp_cmdshell

• by clete

• Redgate

• Reply

I may have found the answer to my problem.  I still needed to add user rights to the account I was using to start up the services.The user rights I added are :        Act as part of the Operation SystemIncrease QuotasLog on as a service        Replace a process level tokenAre there any other user rights […]

2005-02-20

RE: Import external data

• by ROCNDAV

• Microsoft MSDN

• Reply

Insert into a temp table that will be blown away. Then create an "unmatched" query by left joining my existing table with the temp table. Off the top of my head INSERT INTO tblExistingTable (Field1, Field2,etc..) SELECT TT.Field1, TT.Field2, TT.Field3 FROM #TempTable AS TT LEFT JOIN tblExistingTable AS ET ON TT.SomeUniqueField = ET.SomeuniqueField --THis is […]

2005-02-15