Well Mel sounds like you got rid of the sisters, how about the rest of the village/town/city 😛

can you post the execution plan for the query, if you need help in doing that, check the links in my signature at the bottom of this post.

Yep , not impressed, especially if my partner saw these emails. if i wanted messages like these i would have joined an adult dating site.

I am assuming that you mean the service account that sql server runs under. if that is the case you can do that using enterprise manager.

sql_lock (10/9/2009)

---

Firstly, have you run CHECKDB on the data base...

ALTER DATABASE [DBNAME] SET EMERGENCY;

GO

ALTER DATABASE [DBNAME] SET SINGLE_USER;

GO

DBCC CHECKDB ([DBNAME], REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS;

GO

Then check the status

SELECT state_desc...

Oh I dont know, there is that guy from italy ya know, name is erm Olgi perhaps he could go for it.:-P

Brad Allison (10/9/2009)

---

Education is very important and I too, am fortunate to work for a company who supports it. We get $10,000 per year for tuition reimbursement on top...

VALEK (10/9/2009)

---

Imagine this.. You work in a medium sized company, using MSSQL2005 and nothing else.

They are very tight on budget, try to be productive, focused and specialised, unlike government orgs...

Only think I would add, is that you if you are doing a full backup every day and tran log backups every 3 hours, you could be looking at more...

Why does it say it failed.

As mentioned in previous post, using the sample databases will help you more than generating your own databases. work with the tutorials that are in place for the adventureworks databases...

Chan Wai Yin (10/9/2009)

---

Hi,

Thank you for reply. Our goal is to make 3 databases on 3 different servers can synchronize with each other when any one of the server is...

Special user?, I am assuming you mean a sql login, what is the OS of the machine...

namnl (10/8/2009)

---

Hi every body, I had a security issuse and wish for a help.

I bought software for customer and this software require local database.

So, i set up database in...

Try these links

http://www.accelebrate.com/sql_training/ssrs_tutorial.htm

http://msdn.microsoft.com/en-us/library/ms170246(SQL.90).aspx

http://www.simple-talk.com/sql/reporting-services/beginning-sql-server-2005-reporting-services-part-1/