Create the SQL Account with a password. Alter the connection string, substituting sa with the new account name, and substituting the sa password with the password for the new...

quote:

---

I agree with you about ‘sa’ account. My question is if I don’t use ‘sa’ to connect ODBC, which account should I...

Re your points:

2. I don't recommend, and think almost everyone who uses this site would agree, NOT to use the sa. If your connection string has to have...

quote:

---

Anyway, the best method I've used is retrieving the Data into a Recordset / DataSet (this way you can use Standard SQL...

If your web pages are directly accessing the database, as most coding samples in books do, then you should set the connection strings up and trusted connections, and manage your...

quote:

---

How do I access a cube created using the Analysis services from SQL? I can only find references using pivot tables...

Hi Frank,

We create the NT Groups, assign the groups to SQL Server with the permissions needed by the groups. The users are in each group are maintained by the...

If others can get into it, it sounds as if you created the database under the system mdw. If so, you will never completely secure it, because Admin, the...

Excellent solution. One small suggestion:

CREATE PROCEDURE dbo.spRef_GetCertifications

(

@activesOnly bit=0

)

AS

SELECT ID, Name, IsActive, SubmittedOnGMT FROM Certification WHERE IsActive >= @activesOnly ORDER BY Name ASC

This way you don't...

quote:

---

Granting permissions on public.

---

I'd certainly dispute this one as a worst...

To whoever will read on this topic:

Despite claims from numerous sources that bcp and BULK INSERT can use format files to import fixed width columns, this does not seem to...

You can use a non-correlated sub query in the WHERE clause with a focus on the keys.

INSERT TABLE A

SELECT 

FROM TABLE B

WHERE TABLE B KEY NOT...

Is there any chance you can use MTS, because if you can, you can set up MTS impersonation. The users get access to the code in the package from...