Chris Conner (5/7/2009)

---

Thanks for your responses! Ed, thank you for that fantastic reference. It would have been EXTREMELY helpful about 3 months ago! 🙂 But it will...

I'm pretty sure it's not possible.

Lee From Bangalore (5/4/2009)

---

Thanks Dugi

the users are administrator in Operating system

In sql server also they have Sysadmin.

But in sql server I dont want to give the sysadmin role to those...

I've had this happen to me. Change the owner of the db.

I haven't found a way yet but would be interested if there is a solution.

I'm a newbie at this but here is my solution to the second tougher example. I think it's right. I get the same results back.

Select h.SalesOrderID AS OrderNo,...

Well, that'll learn me. This was sent to me by someone else and I didn't really verify if the...

Chris Morris (4/9/2009)

---

Then a brief process of elimination:

SELECT E.[IncidentID], CAST(E.[IncidentID] AS NVARCHAR(25))

FROM store.dbo.orders E

WHERE CAST(E.[IncidentID] AS NVARCHAR(25)) LIKE '%.%'

Edit to add comment: This is the only column which doesn't have...

Chris Morris (4/9/2009)

---

Try...

Nope, it doesn't work that way. From BOL

db_ddladmin

Members of the db_ddladmin fixed database role can run any Data Definition Language (DDL) command in a database.

db_datawriter

...

Tim Walker (4/8/2009)

---

Sorry just reread your previous posts and you are expanding by 100MB. Why not change this to 99MB so it can't regrow to exactly the same size? This...

Tim Walker (4/8/2009)

---

You can find out when it expanded by looking in the ..\Microsoft SQL Server\MSSQL.1\MSSQL\LOG directory. By default SQL creates trace files in there and one of the things...

Yep, It will go right back to 12300 MB exactly.

Results are

Currently allocated 11300.00 MB

Available free space 798.88 MB (7%)

A maintenance plan that rebuilt indexes could cause this kind of effect. I guess a good clue is if your shrink leaves them pretty much full?[/quote]

Nope, I leave...