Everything is possible....

If you want to be able to have execution control, use a sqlagent job.

just my 2ct in addition to Lowells reply which serves exactly your question.

Here's another way to avoid having to grant higher privileges ...

Have a look at help to tighten use...

- 2GB is indeed the limit for SQL2000 MSDE

- did you detach this db ? If yes: Why ?

Can you post the errorlog.n file that was active at the time...

1) Lose the dynamic sql as this query sequence really doesn't need it !

2) collect your data using a join / group by combination ! Think set based in stead...

First of all, these are not the same queries as they may produce different results !

Refactored they look like this :

select PO.PurchaseOrderID

, PO.VendorID

...

- you posted on a sql2000 forum. Is your sqlinstance a sql2000 instance ?

- What's the size of the db ? ( sql2005 express -> max 4GB / sql2008r2...

amod.professional (2/21/2012)

---

hi,

I have data of 182 GB and ram 16gb with 8 logical cpus(2 quad core)

and [erfromance is very poort due to 13.45 GB of RAM is in used with...

suppose your varchar(max) data is off row, that may cost you a extra io to get to the first address of your varchar(max) lob storage. Keep in mind IO is...

Ronnie Jones (2/19/2012)

---

Hello All,

Currently, we have an instance with many databases some consisting of only two tables etc. I’m thinking about setting up a database to support some of those...

of course, Gail hit the nail on the head once more 🙂

ref in BOL: Data Type Precedence (Transact-SQL)

smallmoney has limits ! - 214,748.3648 to 214,748.3647

The engine will try to return a result in the same data type.

ref:http://msdn.microsoft.com/en-us/library/ms179882.aspx

Have a look at this little article for the refs: http://www.sqlservercentral.com/articles/powershell/76405/

Have a look how Grant summarizes it all:

http://www.sqlservercentral.com/Forums/FindPost684939.aspx

and here's another forum thread where I summed up my guidelines ( ... see how things match 😉 )

http://www.sqlservercentral.com/Forums/FindPost1033453.aspx

This may not be the most optimal solution, but it may be a start ...

for ($i = 0; $i -lt $data.Length; $i += 4){

$name = $($data[$i] -split 'Found file ')[1]

$group...

It depends.

A drop table removes the object from the database. (including indexes, grants, ...)

What would be the difference of using a temp table ?

A truncate only removes...