When you link the table you could check " rember password in connection string"

i tested some otherarticles , but this one seems the only one with this behavior.

Hi, do you mean with prepared statements sql embedded in the application code?

If so then one of the advantages of stored procedures is that maintenace will be easier if tables...

hi, no i don't know exactly, i could not finding a restriction in bol. I think the only check is the unique name. The same applies to indexes, you could...

Hi, i think the best solution would be just drop all and create again. In the script you can give a constraint name so that you easier can delete it...

hi, can you post the code you use to connect. Security information removed.

when i understand correctly

first put server in single user mode

From a command prompt, enter:

sqlservr.exe -c -m

then restore the master database.

after the master is restored you can restore the other...

Hi,

what version of sql server?. In sql 2000 in northwind database, in the table employee there is a column photo, which has pictures. I created a linked table to...

Good article , nice to have all waittypes described

Hi, did you try

EXEC sp_createstats 'indexonly'

This create statistics only for columns with an index.

Hi i runned both statements in qa and the execution plan was the same but the statement with coalesce was a little faster. I don't know why and probably this...

When you create your trigger use NOT FOR REPLICATION. (see details in bol , search for create trigger)

select statename

from states

where state is not null

and state <> ""

group by statename

i think something like this is what you want.

--insert header row

insert into tblheader (col1,col2,billno)values (val1,val2,billnoval)

--decalre varto hold billnumber

declare @billno integer

-- get bill number

set @billno = (select billno from tblheader where...

you could generate a script with enterprise manager na drun that script in the other db