have a look at this SP

SP_ATTACH_SINGLE_FILE_DB

BOL Ref - ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/13bd1044-9497-4293-8390-1f12e6b8e952.htm

chr_koffe (1/21/2009)

---

you coul try giving to the account builtin/administrators only public access , maybe the issue is that your account has the privilegies but it first searchs the group...

the best two options would be to either backup and restore (if you want to keep the database on the origional server as well) or detach and reattach if you...

I am also open to any other suggestions of how i could read this data into SQL/ from SQL. I only have SQL 2008 workgroup so i dont get...

madhu.arda (1/2/2009)

---

Regarding item#2:

We have data files on D drive and log files on F drive and tempd on G drive and Backups are Z drive ,but still SQL BPA telling...

what does the structure of "aaa" and "bbb" look like? Instead of your select * you need to select the one value you want. if you think about...

why dont you use a UNIQUE contraint rather than using this trigger for data integrity? Then get your app to check that the insert doesnt fail, if it does,...

ive sussed it, the recovery model (tran logs are backed up hourly) and the alter table were not the culprit after all. I had started to replicate a table...

Perry Whittle (11/12/2008)

---

not logged under simple or bulk logged recovery models...

ok a quick update, i amended the logscan threshold from 500000 to 5million. I left it an hour and still no luck, tran log was still growing and disk...

TRACEY (11/12/2008)

---

There is one error out there on the latest patches that references transactional replication.

What service pack are you on ...we are on CU6 and not had these problems...i have...

Thanks for the quick reply Gail, its the transaction log on the publicated database. I have just found out one of the developers has indeed run an alter table...

why would you want to loop it? why not batch load it?

if you really want to loop it declare a variable as int, set it to 1 and do...

what edition of sql is the new instance? I think that Express doesnt ship with maint plans, and possibly workgroup edition too (2008 Workgroup definately doesnt)

Jim Russell (10/2/2008)

---

Before everyone jumps on the "never SELECT *" bandwagon, I'd argue that there are cases where * is both useful and appropriate. One example is a view that...