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...

This will work a little better:

USE TEMPDB

BEGIN TRAN

GO

CREATE TABLE MY_TABLE(

THE_VALUE_A CHAR(1),

THE_VALUE_B CHAR(1),

CONSTRAINT CHK_A_AND_B 

CHECK (NOT(THE_VALUE_A IS NOT NULL AND THE_VALUE_B IS NULL)))



GO

/* insert ok */

INSERT INTO...

Am in agreement with the previous two. Backup to disks first. Backup those backups to tape.

If you use transaction logs, one quirk I have found is that...

If you can set up this domain account with an email, it is easy to set up the SQL email system to notify when jobs are complete etc. I...

You could do the restore to the production system but with a different database name. This is hardly ideal, because you will have to be very careful.

I...