Steve Jones - Editor (5/27/2009)

---

The question has been corrected to fix the typo and include an ORDER by clause.

main.denis, sorry we are not responding fast enough for you. It is...

Gift Peddie (4/21/2009)

---

When you add your intranet users in your AD group make sure you also add them manually into SQL Server and the databases used by that application or...

As Brandie mentioned, having AD groups in place with the individual users, which you probably have already, facilitates much more the administration at SQL level, where you only would need...

I had to go trough the painful task of updating the Collation.

Here's the command I used:

This will rebuild the master databases. You...

I love it when the explanation contradicts the shown correct answer.......

You need to do Database Mirroring between 2 instances of SQL, so in your case you should probably use your first option, one server attached to one SAn and the...

Permissions must be granted to users only on the module itself, without having to grant them explicit permissions on the referenced objects.

If you wanted explicit permissions...

SA.. as Ramesh asked above, do you see that entry on your SQL Server log? This would indicate that SQL Server is properly taking the changes and actually using them.....

I guess in your case, as you need it mainly for reporting, Mirroring with Snapshots should do. You'd only have to device a functionality to keep the snapshots updated, with...

You can't use mapped drives directly, use the UNC path to the shared folder.

Also, make sure your SQL Server is running under a domain account that has the proper permission...

I'll match the other 10%

From what I have been able to find, that is the only way......

...as mentioned above, use EITHER the IP address or the servername.. NOT BOTH

There is a much easier way, without encryption.

You can define col2 as either a varbinary or image type and cast the string into it. To Select, from your app, you'd...

Is 192.168.2.117.sprintdev.local reachable? Most likely not.... try only with 192.168.2.117

... and adding on to Mohit, the initial size of the Snapshot will be 0 and it will grow as data changes. This way Any data retrieved from the Snapshot...