Ninja's_RGR'us (10/1/2007)

---

In this case : Where MyCol < 'whatever' OR MyCol = 0

One implies a range seek and the other one an index seek (rid lookup). I don't see...

Nilssond (9/27/2007)

---

I have a table (MyTable) with multiple eligibility segments for members. Typical data looks like this:

MemberNumber StartDate ...

Steve Jones - Editor (9/30/2007)

---

Whatever technology you use, you need some sort of application that can control the printer. I don't think SQL Server is a good place for this....

Derek Allan Thomson (9/11/2007)

---

The "Table" table will potentially contain several thousand records before the batch process tidies up the table at the end of the week. The solution offered will...

I have had jobs where I have done everything from setup the office to manage the SQL Servers depending on need and I would say most of us are willing...

I know this would take some extra time, but why not allow the users to subscribe to Forum sections they want to see in the newsletter. That way if...

Michael Earl (9/26/2007)

---

You can actually do this through reporting services directly. The data-driven subscriptions allow you to specify a list of recipients (and other options such as parameter values)...

Jenny,

Can you successfully run the query against the linked server without using variables? What version of SQL Server is each server? There are issues with linked servers between...

See the thread at http://www.sqlservercentral.com/Forums/Topic402212-150-1.aspx

Karen Lennon (9/24/2007)

---

No help here- just wanted to add that I've had the same problem and have not found a suitable solution.  I even tried editing the job that is...

I can't say I'm suprised.  I have seen many companies that don't understand the value in training.  You are expected to keep up with the latest technologies on your own...

Good article.  Can someone explain to me how the bitmap is created when an update takes place?  I can envision using this technique in triggers when archiving/logging.

Benjamin,

The ADO.NET has a tranascation object so can issue a Begin and a Commit/Rollback as appropriate.  If you google ADO.NET transaction you will find the syntax for it.

Ross,

I have never actually gotten a credentials prompt when deploying reports.  Usually I get a "cannot deply error" when there is a credentials issue.  Can you access the Report Server...

AiJaz,

After playing with this a little it looks like Restore FileListOnly returns only the files of the first database placed in the backup file unless you use WITH file=n.  If you...