a single, master table tracking all changes and the original values isn't really going to work well...think it through with me.if you want to keep old and new values, you...

sure!

more information about SQL2008 Change Data Capture

so many acronyms on the internet...no way for me to know or infer what MDS was...

ok, i googled a little bit for you here:

http://www.google.com/search?hl=&q=Master+data+services+unauthorised.aspx

and i found this information at...

yep there's a built in function to help;

PARSENAME; give it a try, here's an example:

SELECT

PARSENAME(TheString,4),

PARSENAME(TheString,3),

PARSENAME(TheString,2),

PARSENAME(TheString,1)

FROM

(SELECT '192.168.1.55' AS TheString UNION ALL

SELECT 'Discount' UNION ALL

SELECT 'dbo.Discount'...

is the "MDS homepage" here on SQLServerCentral.com, or somewhere on the internet?

doh Gail beat me to it..i found the example in my snippets:

GRANT EXECUTE ON Schema::schemaname TO <RoleName>

for the default schema... if you leave out the specific objectname it it grants to all objects:

GRANT EXECUTE TO [YourRoleName]

i think for a specific, non-default schema, say QA schema i...

can you post the execution plan as a .sqlplan file here as an attachment?

maybe we can see something you overlooked? a second pair of eyes never hurts!

also, why is there...

What?...

regularly scheduled transaction log backups throughout the day.

a database in...

sdownen05 (6/6/2011)

---

We all know the command to change from one table to another in SQL code:

USE Table1

GO

USE Table2

GO

My question is this: Is there a way to change from one database...

SQL2008 introduced CDC...Change Data Capture...which is going to do everything you are asking and more, it's built in and it's documented, working and can be implemented on each table you...

every object is resolved to a four part name when a statement is compiles

ServerName.DatabaseName.SchemaName.ObjectName

ServerName.DatabaseName.SchemaName.Tablename

sometimes you can skip explicitly nameing the object and leave the word between the periods out, and...

cino (6/5/2011)

---

I even notice ppl using ## or ###, does this have another meaning?

Is this a common good practice? Or is there other specific good reasons we are using these...

i think a quick google and read would be more beneficial to you than a brief forum post; once you've read up on the subject a little bit, if you...