you could also consider a server side trace, with a filter on the HOSTNAME property to match the machine you want to watch

the problem with that is it's possible to...

SSIS has a Transfer logins Task as...

Microsoft provides a downloadable query named...

inside a cursor, that's normal; what you want to do instead of print is raise a low level error inside via RAISERROR the cursor so you can see things...

you could place GO statements between each command, but you still have to manually ignore the errors...makes it hard to determine which are "ignorable" errors and which are real.

instead, consider...

gary.p.heath (3/6/2013)

---

I am trying my best to get my head around SQL Server but seem to be going around in circles. Everything I google is either way too complicated for...

excel automatically treats anything that looks like a number as a number, dates as dates, etc

I believe you'd have to change you report of the data to explicitly place a...

grab it again; i edited it and retested it on my machine, it seems to work now.

this is what i would use to review the trace:

--SELECT * from sys.traces

declare @TraceIDToReview...

as far as i know, you cannot alter a user defined type.

you have to remove references to it, drop it, recreate it with a new definition, and then re-establish the...

there's a couple of ways to tackle this, but it depends on what the focus is:

if you want to absolutely prevent the login from UPDATE, you'd create a group,...

it's not obvious where the alias goes;

here's two examples:

SELECT POPRCTNM,

STUFF((SELECT ','+ CAST(ACTINDX AS varchar)

FROM POP30390...

a CLR has access to all tables in the scope of the transaction if you use the context connection; (ie #temp tables and @Tablevariables

one option is to have the CLR...

That trigger emulates what a column with an identity does... so you can simply define the column as having an identity and skip the trigger completely.

Create table tbname (colname int...

it's possible, but you have to register your DLL into the database as an assembly, before you can create a CLR which uses your Medical.DLL as a reference. You might...

probably one of the best maintenance solutions out there is this free, peer reviewed, used in major production facilities and major companies solution offer by the world renowned SQL DBA...