Yes, it is the same amount for memory.

http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_8dbn.asp

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

Jean - thanks for that, good to know about this as I'm sure this problem will come up again in the future (at least until SP4).

--

Chris Hedgate @ Apptus Technologies...

Relations per definition are unordered, therefore your results from a query missing an ORDER BY can theoretically come in any order at all. You can never be sure of which...

quote:

---

Thanks for the great article.

Btw: the link to script 1 is broken, there is a space in '.t xt' and the URL...

chance, the problem here was that a trigger on table inserted to was resulting in @@identity returning an unexpected value, i.e. one from a second insert done by the trigger....

OK. Well, then yes, you can catch the error and take action as necessary. This small example should describe what you need to do:

create table a (b int primary key)

insert...

Mazi, I think the active threads show only those threads that have received a new post since your latest visit. So it is only for you it is not visible...

I've never seen that Tim. I also only use the sp_-prefix and it works fine. sp_MSmarksystemobject just marks the object as a system object. That means is you have to...

2GB

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

How is the report generated?

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

The code presented by mromm is very nice. You can also take a look at the PERMISSIONS function.

SELECT PERMISSIONS(OBJECT_ID('Orders'))

Look up the bitmask of possible values in BOL.

--

Chris Hedgate @ Apptus...

Interesting. Do you have a URL sqljean?

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

Dalton, great that the problem is solved!

quote:

---

- Why?, in "security" options in my database inside SQL Server, did I have to set...

Never used it myself, but I can't see how it would be a problem, since logical file names are local to database.

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

I don't really know if blob data pages are cached as other pages, but I don't think it would be a problem for you since they are only used a...