This will get the file into a temp table.

You have not said what you want to do with it from there....

IF OBJECT_ID('tempdb..#xmlTable') IS NULL

CREATE TABLE #xmlTable (xmlCol XML);

DECLARE @sql...

Well, it depends what you want to do, but here is a snippet taken from a routine I wrote along those lines:

DECLARE @sql VARCHAR(MAX);

DECLARE @FileName VARCHAR(512);

SET @FileName = 'c:\myfile.txt'

SET @sql...

Hi,

I didn't like all the RBAR so I had a go at a non-RBAR and came up with this.

It is a bit hard to read because of the complexity of...

have you tried restoring file associations from within BIDS?

PaulB-TheOneAndOnly (7/1/2011)

---

mister.magoo (7/1/2011)

---

That sounds like an amazing project - please tell us the name of your product so that we can keep an eye out for it. Not to avoid...

That's not real data is it?

MuskaanGoyal (6/24/2011)

---

Hi,

I have a requirement to restrict everyone (including DBA) from accessing user defined sql server database objects (like tables/function/views/stored procedures triggers etc). No one should be able to select/modify/delete/drop/disable...

No, don't be embarrassed, I quite often rely on talking to others to spark something - face to face it often happens before you finish the sentence, online it can...

I would guess that login 'A' has the processadmin server role - that does not show up in server_permissions.

No, what we learnt here was...

I tried it on my desktop and got it to run in about 5 minutes by a small change...

SET NOCOUNT ON

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id =...

because your default collation is compatible with non-unicode characters

Collation, Collation, Collation 😉

try this : select CHARINDEX('a',N'a?' COLLATE latin1_general_bin)

Your db collation most probably not compatible with the unicode characters you are using.

The extra code at the end is part of the WHERE clause, not the join!

and stcyt = '201110'

MY usual interpretation of ownership in this arena comes down to "who can make changes to the code".

In some cases, the DBA can make changes to the code - if...