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

easiest route is this

1.create a new blank database in SQL

2.right click the new db --> tasks --> import data

3.follow the wizard step by step up to Save and Run package

4.save...

happy to help.

as i said in my original post, what is the business requirement for having dates as varchars? if there isnt any, I would recommend putting a task...

first of all, can you detail why you are storing dates as varchar and not datetime and what is the business requirements for doing this

secondly you could set dateformat =...

thats good that the database has come back online, but the root cause should be investigated as to why the DB went into recovery_pending and should be fixed to stop...

if you have the operators already set up on the job then it should work, as you have not change the way in which SQL agent sends its mail, just...