the script you pasted, assuming a missing closing-parenthesis, makes [IsRegistered] the table's primary key; was that the desired results? was there something missing like a comma and the rest of...

not directly from MS, no table level backups.

I believe some of the RedGate stuff does it, and i know you can script out the table and the data right from...

excellent point, David. sometimes you need...

Danny i think this is just a basic syntax issue;

if you are building a string that ahs a single quote in it, two single quotes in a row signify the...

replication does not require a constant connection; merge replication, for example, would stack up untill it got PULLED; log shipping would be up to the other end to grab...

--edited and removed when i found out it was homework.

For homework, me pasting a solution helps noone; you never learn...

even with the maximum compression settings a backup file that compresses to 200meg might go to 189meg with higher compression; there is no miracle compression that will shrink a gig...

what would the function do with the values if it got them? you might be looking at a problem head on, when a sideways look might present a better solution.

what...

chaturvedi.garima (4/30/2010)

---

Hi!!!

The variable is initialized in a stored procedure with the value present in a table.

It is disappearing at later point of time.The data type of variable is Char.

Tried to...

show us the function dbo.GetNextID()

we canhelp you turn it into an inline tablevalue function which can be used for multiple rows;

your syntax for usage would change only slightly:

INSERT INTO destination_table

...

I can think of two ways to do this;

first, lets think it thru: you can find a group of chips that have been salted, right?

--chips that had salt

select distinct chips...

gotcha;

I worked around the issue by combining the two triggers into one.

my logic is on insert, the external id is ALWAYS the Identity ID; you can change it later.

this does...

George Murphy (4/30/2010)

---

Thanks for your help. (mssqlserver 2005) I have a table called tier1 and a column named class nvarchar(150) it needs to have a default value set on that...

instead of using SCOPE_IDENTITY, it's usually recommended to use the OUTPUT clause to get the values inserted;

the advantage is similar to how you have to construct a TRIGGER: often times...

i think it's due to the query; do a select * from sysusers in any database. there's no Builtin\Administrators in that list.

the query is not showing implicit users who have...