RE: Private Folders ...

You have GOT to be kidding ... I'm just waiting for the day that we suddenly have a bunch of folders on our file servers that the...

We use notes, and I had to use a VB script to send mail when an event happens. Part of my problem though, was that our IT folks had their...

This is a common problem in many sites that support forum/blog type entries. What I (and many others) do is write our post in notepad or other text editor, then...

Try the following:

select Distinct CustomerName,CustomerNumber,SalesmanName,Min(ItemDescription) AS ItemDescription,OrigionalDateofService,InsuranceCarrier, Diag1,Diag2,Diag3,Diag4,

min(ID) as ID

from O2

Group By

CustomerName,

CustomerNumber,

SalesmanName,

OrigionalDateofService,

InsuranceCarrier,

Diag1,

Diag2,

Diag3,

Diag4

This will still allow you to get only the distinct combinations of your data w/o having the ID field...

One more thing to look at: Check your network. If your network becomes saturated (i.e. too busy) during the moment when MOM is trying to attach to the SQL Server...

How "up-to-date" does the central database need to be? If 'next day' is OK, you could do something like log shipping every night to update your central repository. Since things...

Actually, there's lots of kinds of DBMS's that are not relational. There's VSAM, ISAM and it's variants, there are network databases and even stranger things out there. Your choices are...

It's a dumb suggestion, and you probably already thought of it, but is it possible that you have encryption services installed on your computer (where you created the DTS pkgs)...

Now, that's an interesting detail. I do have a computed column in that table - but I've always had a computed column in that table. What's interesting is that the...

Very curious. I'll try just scripting the DBCC command. What's odd is that this is happening halfway through the reindex process. I can see in the maintenence plan report that...

Hrrm... I have a stored proc that I can run to grant all necessary permissions. What I'm seeing is that when a subscription is added a new table is created...

Andy - regardless of the validity of primary keys and clustered indexes, the "it's so easy" argument doesn't hold water. That isn't a reason for a best practice, no matter...

How would you recommend using a reference table of users and permissions to grant permissions automatically? Use a job timed to go off after the table should be reloaded and...

Hmmm... you're doing a log backup to shrink the log file? That'll be what's messing up the chain. I set ours to shrink the log automatically with every backup. Since...

Overall, blades have worked out really well, technically (political issues abound, but that's neither here nor there). We have a pile of servers on blades, doing everything from 200+ gigabyte...