Not doing insert...

Hi Vedran,

I couldn't quite connect your two sentences: "Heaps have no indexes" and "Try using TABLOCKX".

Nevertheless, I did try TABLOCKX to no avail.

Hi Gail,

As mentioned, the database is in SIMPLE recovery model.

Best,

Yusuf

Thanks Chandan and Chris,

Have already tried the OPENQUERY and the recent EXECUTE AT remoteserver feature (latter having the much needed ability to pass parameters) and both work wonderfully well for...

Why so harsh Steve? It's a "Stairways" article. All writers must consider their target audience. I thought the article was a great primer on bookmarks, indexes and heaps. The three...

Wowww.. All the more reason to wrap your dataset queries inside stored procedures!

You can grey out a parameter by basing it on a previous parameter. Create a parameter useDate and give it available values of Yes and No.

create a...

tmacs33,

The question is : How do we grey out a report parameter (date type or not)?

If greying out can be achieved, the SSRS world would be a happier place 🙂

Jack,

That is what we have been doing to effectively disable the report params based on other params.

But, can you suggest how to do so if the parameter is of the...

I am not very clear on your requirement. But this could be one solution

Execute SP1 from inside SP2 (where you have declared the #menu temporary table)

Populate the #menu table in...