you cant, you just need to make sure that you have a very tight server, logins are check for any permissions they shouldnt have, parameters being passed in to procedures...

most attacks come from the internal network, so saying your end users go no where near the table is great, but what about your internal users. you might have...

that links with what the article was saying

the db was detached by user1, SQL then gives only user1 access to the files of the database anyone else including administrators are...

i would uncheck everything on the settings tab to be on the safe side.

other than that, I cant think of anything else which would send a break to the command...

the task isnt set to stop after X amount of time is it, usually the default is 72 hours

so you issued for example

alter database model alter file (name='modeldev', filename='e:\model.mdf')

after which you restarted SQL, but the server would not start

this is due to the model.mdf being in C:\Program File\Microsoft...

have a look for a program called handle from SysInternals, this should tell you which processes have locks on files, so you can cleanly stop them to release any OS...

when you moved the model database, did you actually move the database files?

temp db is created upon the startup of the instance of SQL so will work by just doing...

IE will use windows authentication if it can and only if it cannot authenticate then it will prompt for a username and password.

Your windows account must be granted access to...

UNION ALL does give duplicates, if you dont want duplicates use UNION

you talking about when you went to the reports url e.g. http://reportingserver/reports or within bids on the data source?

if is the URL then you need to go into your...

union or union all can only have 1 order by so you will need to remove the first two order by

eg

select

col1, col2, col3

from

table1

union [all]

select

col1, col2, col3

from

table2

union [all]

select

col1, col2, col3

from

table3

order...

I used to get this problem a lot, and the article that Gail provided is great.

We where in a multi domain environment, parent, child eg

domain1.com

subdomain1.domain1.com

subdomain2.domain1.com

There where servers in all 3...

extract the ssis package from server1 then upload to server2

this is assuming that you have the same config, database names etc on server2 which are detailed in the MP's on...

excellent, thats good to hear