i'm migrating all columns. the problem is the image column, which i have read cannot be used in import/export. (still don't fully understand why!) i have not found a suitable...

Ignacio A. Salom Rangel (8/26/2011)

Try to give the new group you create in the AD rights on another database and see if then you can connect to the other database...

Ignacio A. Salom Rangel (8/26/2011)Have you try removing the problem users from the Windows Group and adding them again? Is there any change that the specific users have been denied...

where should i see individual users? in SSMS, i expand security / users and i only see the groups listed.

i haven't deleted the group because there are other users connecting thru it.

i did create a duplicate group with the same properties and db mappings and added my problem...

how can i see the collation at the column levels? i want to check if the db i exported to on a test server has the same collation on the...

ciao gianluca,

the article seems to deal with changing the collation of the system databases. i don't want to change the server, only the database. does my method above seem...

another thing to note: when clicking on the login properties, if i open properties and directly click on securables, i do not get an error. but if i open properties...

thanks for the suggestions. i've checked everything but nothing comes up. in fact, it's even stranger now, i added a sql auth login for one of the guys today and...

I don't have any hands on experience with partitioning but here's some doc I found:

Partitioned Table and Index Concepts

http://msdn.microsoft.com/en-us/library/ms190787.aspx

Check out the partition parameters in the ALTER INDEX command:

http://technet.microsoft.com/en-us/library/ms188388.aspx

As a policy, no. I would never let WSUS automatically apply a SQL service pack. Typically, I apply service packs on test servers first, then lower priority servers, working my...

Thanks to everyone for the replies and useful information. Here are some replies to your questions and comments...

I think the most important question to answer when trying to decide...

rather than using the mirroring "gui" in SSMS, perhaps you can change the parameters in a script. go thru the mirroring setup in the gui, with the 5022 ports, and...

thanks for the reply, matt. that has clarified the process a lot for me. i guess it depends on the volume of logs and the amount of downtime, whether it...

JeremyE (6/3/2011)

---

Since the database is already in full recovery, I assume you are already running tlog backups every 15 min. You can query msdb.dbo.backupset to pull the transaction log backup...