Viewing 15 posts - 256 through 270 (of 535 total)
definately nothing to do with the database size as has been stated. look at the error code in the job history and you should be able to work it...
July 29, 2009 at 8:45 am
I "think" ive managed to sort it by dropping the merge replication and using transactional with updatable subscribers.
July 28, 2009 at 5:09 am
Richard M (7/22/2009)
Peter D (7/22/2009)
+ 'WHERE kpid = ' 7116
kpid is numeric, so you should change that to:
+ 'WHERE kpid = 7116 '
its not because its numeric, its...
July 22, 2009 at 10:02 am
Ill reply in here although there is a seperate forum for certs... http://www.sqlservercentral.com/Forums/Forum10-1.aspx
The best place to start is by getting yourself a developer edition of sql 2005...
July 22, 2009 at 6:03 am
Peter - silly question i know but did you actually put the KPID id in the script where it says to?
July 22, 2009 at 5:54 am
An excellent trick to have up the sleeve that one Scott, thanks. Never seen it documented/mentioned before but its definately a neat approach to CPU spikes.
John
July 22, 2009 at 5:53 am
Take a look at this script, its a bit rough and ready but will show you at a high level what you need. you could amend it and put...
July 22, 2009 at 3:13 am
reddyk (7/21/2009)
These are my counters for SQl Server memory: both look the sameTarget Server Memory:14377680
Total Server Memory:14377680
Should I be changing the max threshold?
your sql server is not set to use...
July 21, 2009 at 1:22 pm
your biggest problems normally come from connection problems if one of the servers is offsite etc. Data issues (checking the validity of data at both sides). if your...
July 20, 2009 at 1:07 am
If your working in a predominately 2005 environment then it would make sense to do that exam as you have already studied for it. If you are (or are...
July 20, 2009 at 12:41 am
USE [Master]
GO
CREATE USER [tech12] FOR LOGIN [Tech12]
GO
grant execute on xp_cmdshell to tech12
go
July 15, 2009 at 6:32 am
the user needs execute permissions on the extended stored proceedure which is in the master database.
July 15, 2009 at 5:29 am
in what context?? file placement/performance/difference between the two??
July 11, 2009 at 5:51 am
another really nasty way which in theory would work would be to put an update trigger on the table itself and count the number of rows in the "inserted" table....
July 8, 2009 at 10:30 am
If your limiting the SQL instance to only use X amount of memory though then the OS will happily take more than 1gb RAM.
July 7, 2009 at 6:55 am
Viewing 15 posts - 256 through 270 (of 535 total)