Viewing 15 posts - 8,296 through 8,310 (of 9,641 total)
You do not have to drop the Primary Key constraint on table1 as you can update values in a Primary Key Column. Have you attempted to isolate the alter...
July 23, 2008 at 7:56 am
It would be easier to read your execution plans if you saved them as .sqlplan and attached the files to your post. Then we could open them in SSMS...
July 23, 2008 at 7:42 am
GSquared (7/22/2008)
I recommend against messing around with the code in msdb. Don't change the trigger, don't add one.Manually modifying that kind of stuff in system databases always bothers me.
I'm...
July 22, 2008 at 2:02 pm
Dev (7/22/2008)
My requirement is to compare count of a table between a hour difference and if it remains same i do the next task.
For exapmle, here in the below...
July 22, 2008 at 2:00 pm
Are you getting it for any other Windows user or group? Can you get a test Windows user setup for you to experiment with? Do you have another...
July 22, 2008 at 1:52 pm
Not that I am really advocating this, but you could put a trigger on the sysjobs table in msdb that logs changes. There actually is already an insert, update...
July 22, 2008 at 1:50 pm
Jeff,
When I run it the only difference I get is on the first one where there are no duplicate addresses, so depending on how you code it you get a...
July 22, 2008 at 1:20 pm
Perry Whittle (7/22/2008)
datareader only applies to user tables so should be safe
Sure, but it applies to ALL user tables in the database. Using the datareader role is usually a...
July 22, 2008 at 12:18 pm
Perry Whittle (7/22/2008)
the datareader role should grant select on tables.of course you could modify the public role but i wouldnt recommend that
This would work but provides more
than the minimum rights,...
July 22, 2008 at 11:57 am
ctics112 (7/22/2008)
My apologies for not explaining the situation thoroughly. The stored proc is returning agents from states other than TX, FL, and LA. It is just that those states are...
July 22, 2008 at 10:33 am
You need to include the data type before the not null.
Alter table dbo.table
Alter Column column_name Int Not Null
July 22, 2008 at 9:42 am
DBCC ShrinkFile ([log file name]). Check out BOL for the rest.
You normally do not want to shrink the log as it will typically just grow again and the growth...
July 22, 2008 at 9:37 am
2 changes:
Count(c.ID)/14 as 'Count' to IsNull(Count(c.ID), 0)/14 will give you 0's
Move sea.ID = 148 to the where clause as euc.SeasonID = 148
Here is the code with the...
July 22, 2008 at 9:31 am
It sounds like moving the files made it so SQL Server cannot verify them before appending the new differential backup.
My advice would be to do new full backups then do...
July 22, 2008 at 9:08 am
Viewing 15 posts - 8,296 through 8,310 (of 9,641 total)