did you drop your temp table so it can be recreated with the new column?

you had a few errors in what you were trying to do;

dbcc inputbuffer returns a table with 3 columns...you have to capture the columns.

your concatenation was not quite right;

hre's a...

maybe you are comparing it to the way oracle works? oracle is very user centric...delete a user, and you delete all the data owned by that user. could be gigs...

with massive updates like that I think it is a lot easier to undo or stop if you did the updates in batches, instead of trying to do the whole...

I'd seen a similar requirement before, so I created this procedure...you have to pass it two parameters: the tablename and the search term.

it uses dynamic sql to quiery just the...

ok, it's the middle of the night, and to boost my coolness, i answered a hundred or so questions in the Question of the Day section;

they don't get added...

oops duplicate reply from me somehow...

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...