Viewing 15 posts - 331 through 345 (of 360 total)
If you add more columns you need to expand your group by clause as well
select 1,2,3,4,5, max(6)
from table
group by 1,2,3,4,5
October 17, 2008 at 2:20 pm
It's been a while since I installed, but isnt' that just a "warning"?
If you don't need it, skip past it. If you don't know if you need it,...
October 17, 2008 at 2:15 pm
I think the proposed solution will work.
You're fortunate that a good SQL Scripter was reading the "backups" forum, because that might not always be the case.
You'd have had a more...
October 17, 2008 at 2:06 pm
Robocopy is fine and isnt' the issue.
The earlier posters that hinted about compression is more likely it.
If you're going to need to do this frequently, you might consider log shipping...
October 17, 2008 at 2:01 pm
That's a tall order, but I can help you.
read up on Create Trigger
http://msdn.microsoft.com/en-us/library/ms189799(SQL.90).aspx
and using the inserted and deleted tables
http://msdn.microsoft.com/en-us/library/ms191300.aspx
so once you know how to create a...
October 17, 2008 at 1:48 pm
If you're talking about schema and not data, and want something cheap and easy I have something for you:
try running a checksum_agg(binary_checksum(*)) from the sysobjects, sysusers, sysprotects, and sysmembers files.
If...
October 17, 2008 at 1:35 pm
What you need is a trigger that reorders the case_seq after an insert or update of case_cred.
This will solve your problem.
Good luck!
October 17, 2008 at 1:28 pm
1. You are correct. If you grant people into model, they will have access in model as well as being granted into any newly created db. ...
October 17, 2008 at 1:25 pm
Clarifying:
If you insert them out of alphabetical order, you want the sequence number to also change?
~Craig
October 17, 2008 at 1:06 pm
2. every time i set the file growth to be restricted for both db and log files.
But after every restore it is being changed to unrestricted . why it is...
October 17, 2008 at 12:56 pm
I'm not 100% sure, but I don't think that matters.
The error I was referring to happens when you drop the PK to which the other table's FK's are pointing.
You end...
October 17, 2008 at 12:43 pm
Somebody mentioned the CREATE INDEX WITH DROP EXISTING, and I remember trying that and the answer is yes... and in EE you can do it online... it's pretty sweet... except...
October 16, 2008 at 3:21 pm
I have several DTS packages running on the same sort of cluster environment (2k3 and sql 2k5) with no problems needing to specify the hostname instead of the virtual server...
October 9, 2008 at 7:44 am
Yes, you are correct.
CONTROL and VIEW DATABASE STATE are all you need for sys.dm_db_index_physical_stats run (if you're not wildcarding the first argument with NULL)
~Craig
October 9, 2008 at 7:37 am
select * from sys.dm_db_index_physical_stats(db_id(),null,null,null,'detailed')
^can get your free space and fragmentation percentage among other things.
select object_name(p.object_id) as Table_Name
,ISNULL(name, 'THIS IS A TABLE') as 'Index name'
,CAST(used_pages as decimal(12,2))/128 as 'Used Size...
October 8, 2008 at 3:13 pm
Viewing 15 posts - 331 through 345 (of 360 total)