Hi, Im trying to create a publication on SQL Enterprise 2000, using Enterprise Manager. This is on a brand new database, and table, and Im getting...
Run this on your database, not on master. The views are special type and available on all databases select * from...
Make sure <the account which sql server is running as> has read permissions on the file and location If the file is on a network, the sql server...
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by...
Whats does the 'application files' involve? Would it simply be a bunch of .exe's? <br />If so, do these applciations write or read frequently to the...
What indices are on the tables? Make sure the guids have at least a non clustered index on them
Is there any firewall in between the servers ? Ping uses ICMP, but ODBC is TCP/IP and so still could be blocked
Sounds like you have a bit of a job on your hands with that one <img src='/community/emoticons/emotion-6.gif' alt=':(' /><br /><br />Is the C/AL...
> Means that for example SPID 51 sets the DEADLOCK_PRIORITY for SPID 52? Couldnt SPID 51 simply SET DEADLOCK_PRIORITY LOW ? Meaning that SPID 52...
If you want it to bge random, then it clearly has no defined purpose, other than to act as an identifier And in that case, identity will be perfect...
Some people are so lazy <img src='/community/emoticons/emotion-6.gif' alt=':(' />
Script each database all out into one big file, and then use the nice and free 'csdiff' to compare<br /<a target="_blank"...
Thats quite worrying :|
Forgot to say, ultimately you need to start running SQL Profiler, to get more insight into whats really hapenning to SQL server when this occurs
Looks strange, for sure.<br /><br />Note that the cpu drop coincides with a surge in new users connecting. <br />What sort of system is using the SQL...
You have torn page detection enabled ? Depending on how big the database is, I think I would try to transfer the database from one server to another...
Ive had this problem before. I believe its to do with memory as Mohammed says, but is not specific to SQL server and doesnt really appear to be...
Consider creating a stored procedure that truncates the table, then just give execute permissions to that user only
if its very very urgent, why not just enabled ALL of them? Its pointless us giving you a list because you should learn about the server environment...
Either youve run out of disk space for that filegroup, or the database size has an upper limit on it Review the database properties in Enterprise...
Separate names with a comma.
