Viewing 15 posts - 36,871 through 36,885 (of 49,563 total)
panwar.jt (8/23/2009)
I like to remind once again that this problem comes only in report display if i run this proc in query analyzer it run perfectly.
In that case, I'd personally...
August 23, 2009 at 11:56 pm
since1980 (8/23/2009)
Reconfigure with override
...
August 23, 2009 at 11:52 pm
RBarryYoung (8/23/2009)
I thought it important that the OP know that between Gail, Sarab and now Mike, you're getting some of the best help in existence.
Well, I know just about enough...
August 23, 2009 at 1:23 pm
newbie2sql (8/23/2009)
sys.data_spaces for the filegroup (for tables only) and either sp_spaceused or sys.dm_db_index_physical_stats for the size (again, only for tables)
Thanks for the info. But how do i find for indexes...
August 23, 2009 at 6:27 am
You'll need sys.objects for the name and type, sys.partitions and sys.data_spaces for the filegroup (for tables only) and either sp_spaceused or sys.dm_db_index_physical_stats for the size (again, only for tables).
If there's...
August 23, 2009 at 6:09 am
luckysql.kinda (8/23/2009)
Yes the older one I have but that is really very old.
If this is critical data, how come you only have one very old backup? Isn't this getting...
August 23, 2009 at 4:05 am
As far as I'm aware, without the certificate the data cannot be decrypted at all.
Do you have an older backup that still has the certificate and master key in? If...
August 23, 2009 at 2:57 am
No.
SQL backups are database, filegroup and file. You could, technically, put the table into a filegroup by itself and back that up, but when restoring you'd still need the primary...
August 23, 2009 at 2:54 am
August 23, 2009 at 2:52 am
I don't have a permanent personal black list, though do have a couple people on the 'I'm not helping them until they change behaviour' list. Currently it contains the PhD...
August 23, 2009 at 2:45 am
Lynn Pettis (8/22/2009)
Lynn tries to work with everyone. 😉
Aren't there a few that have made even your personal black-list?
August 22, 2009 at 12:38 pm
If there's no single unique column in any of the base tables, and full text requires that there is one, then you're going to have to find another way that...
August 22, 2009 at 12:33 pm
Is there absolutely no column or set of columns in the underlying tables that are unique?
August 22, 2009 at 8:21 am
I wrote 432 while it was in beta, just used Books Online to study and MS's exam outline to see what I needed to study. Worked for me, won't...
August 22, 2009 at 8:20 am
Viewing 15 posts - 36,871 through 36,885 (of 49,563 total)