here's the code I use to add a linked server; there's no difference between a linked server for 10G vs 11G as far as I know.

--#################################################################################################

--Linked server Syntax for Oracle...

definitely permissions related...operating system privileges, not related to SQL.

i think if you right click on the shortcut to SQL Server Management Studio, you can choose Run As...

if you do that...

some of the hobby databases that I've done in the past , to help me really understand SQL:

1. gathering lists of city/county/state/zipcode, and breaking them up into parent-child tables:...

i backed it up and put it on the web if you want it;

see the post here:

http://www.sqlservercentral.com/Forums/Topic750105-338-1.aspx

this errors on the forum causing multi posts is annoying.

if you can spare the time, dump a request to some local businesses asking for an unpaid intern position sitting with their SQL DBA. volunteering a few hours a couple...

here you go jason:

i don't think the msi works unless you have SP2a or above installed;

i ran the msi, which drops an mdf/ldf pair in the default data folder so...

that's an easy one for SQL 2005, mohan;

one of the sys views has exactly what you are looking for;

select state_desc,* from sys.databases

the state_desc is usually ONLINE or OFFLINE, but there...

at our shop, we stick useful udf's and procedsures in the model database; everyone(well developers) knows where they are if they need to copy them to a newly restored...

it's a downloadable msi, which attaches an mdf i think; ; too big to actually script out

here's a link to 2005 databases:

http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004

and here's a link to the base page for...

there's two ways I can think of to interpret "lock the table", which is why we ask.

you can "lock the table" with permissions, so noone, or noone but an sysadmin...

there is an optional OUTPUT clause you can use to retrieve all the values that were inserted; typically you insert the output into a temp table and use it for...

timestamp is a misnomer; the proper datatype is actually rowversion;

it is NOT related to time in any way, it is just a unique number which is created/updated automaticall when an...

i think your issue is the NOT EXISTS...

whenever you do that, You have to test for nulls, as that will screw up the EXISTS

WHERE NOT EXISTS

(SELECT OldLicenseNumber FROM...

another way to consider is to take away access to the tables themselves, and only grant access via stored procedures.

then you simply make sure the stored proc will execute onyl...

OK matthew; here's two versions for you, one for 2000, another for 2005;

as you'd guess, the 2000 version gets truncated if you have a huge table definition of 8000 or...