Do I get to keep the point if the question gets removed and the plagiarist is thrown into timeout? 😛

There are many benefits to running a SQL environment on VM. I was part of an IT shop where we had to move the entire infrastructure to HyperV. It was...

Nevermind...I think our server permissions were changed so that I don't have local admin rights on the box. I'm still a sysadmin, but can't stop, start, or restart any services.

I'm just now experiencing the same thing. Have you found out what the issue is?

Thanks for the suggestions. I am wondering if anyone has had paging success with using a subreport within a tablix. If I run the report itself the paging is fine....

Yes, I have tried placing the subreport inside of a rectangle with no success. I have tried all possible variations of break between, break before, break after, keep together, on...

I've just now started to use SSRS 2008 and have already come across this issue as well. I have 3 reports that need to be run individually for an individual...

I've used them for years with no issues. There are some tricks for getting some setup, but have never had any reliability issues. I have links from 2000 to 2005,...

I still have to support a SQL 2000 instance for a vendor application that the business can't afford to upgrade at the moment. The new version of the software is...

In my case, DLookup was being used to find unknown values in a OTLT :w00t: based on a primary key. For example: using a random address book number to find...

Most of the Access queries that I have converted to TSQL use the DLookup function only when using multiple tables. It's quite a neat feature in Access and is commonly...

I haven't used environmental variables because they are local to the system you are running the package on. If you create a variable during development, you need to make...

After you have created/modified a configuration package, your SSIS package will use a defined...

I have found it much easier to maintain connection strings if you store them in a SQL configuration table instead of XML. You can then use simple scripts to...

I like QotD, it gives me 5 minutes everyday to learn something new or refresh my memory. This question was flawed, as some often are. But, it still...