Search results for query: *

The snapshot job should not be run on a schedule if you are using tranactional replication. You need to the snapshot job there for reintializing the subscriptions after you add a new article. In your current setup it sounds like you are replicating all transactions and refreshing the entire...

Unfortunately that was not the value I was trying to change, as I indicated this value only appears in the Advanced tab of the Configuration Manager. The Default database file location is probably one of the easiest to find and change. I ended up just going with the registry setting change which...

Im running SQL 2008, and I have just migrated all my datafiles (including all system dbs) to new LUNs. I was able to change all the paths from the original install to point to the new replacement LUN with the exception of one. In SQLServer Configuration Manager, for MSSQLServer Service on the...

Thanks, I know what NET SEND is for but that is what its sending the alerts through even though its set up to send smtp.

Im having a problem in SQL2005 with job failure notifications. They are working at the moment (Im aware that agent sometimes needs to be restarted when its not working) but all the notifications are being sent via netsend instead of smtp. Is there some setting somewhere that forces it to use...

Thanks - I'll trim down the max server memory.

Thanks, I ran the dropcleanbuffers first but that didnt change the AWE allocated number. name minimum maximum config_value run_value ----------------------------------- ----------- ----------- ------------ ----------- Ad Hoc Distributed Queries...

Does anyone know how to flush the buffer pool for this (aside from restarting SQL svc)? Right now the AWE allocated (KB) is showing ~60GB but AWE is not enabled and I am getting errors from MOM since 98% of memory is begin consumed by this.

For SQL 2000 (SP4) on Win2K3 I need to start reporting on failed login attempts for several servers in the organization. I have set the audit level to capture the failed attempts. Since that only appears to write to the Application event log and SQL logs, is there any other place that those...

Thanks, for the feedback guys! Basically, there are reads and writes going on concurrently and both the read and write procs use cursors to some extent to generate the data dynamicly based on whatever the app is passing. I ahve have found that one of the UDF is used by both and seems to be part...

I have an SQL2000 Ent Ed.(os Win2K3) Active/active cluster that it was suggested that I use transactional replication to alleviate slow responses to reads when updates are occuring. Personally, I would rather just improve the code than resort to maintaining the replication. Is it even possible...

I need to show object level access rights for every object in our BOE XI R1 environment for Sarbanes-Oxley. Does anyone no a systematic way of doing that? Basically, I need to query against the repository to display each users rights to each object. Thanks, Patrick

GREAT, I thought that it should be that easy and it was! It worked like a charm! Even though I could not restore it to the original server. Thanks for the help!

Has anyone ever had to recover deleted local DTS Packages in SQL2000. I think it could be done by restore a backup of msdb, but I'm not sure where to go from there. Thanks, Patrick

That did the trick! Thanks!!

(SQL2000 std SP3a on Win2k3) One of my databases is show negative free space of 9000% in Quest spotlight and 0 MB free in SQLEM when I view the db properties. Does any one know how to correct those stats? I have already done several DBCC CHCKDB and CHECKTABLEs on that database. I suspect it...

I dont think we are understanding you. If the answer is 100 then you need to use the a.cash with the group by, NO SUM INVOLVED, its not correct to sum them if that is the current cash balance after the deposits.

then try this... Select a.account, NEW_CASH = a.cash + SUM(b.deposits), deposits1 = SUM(CASE WHEN trnansactionCode = 5 then b.deposits Else 0 END) deposits2 = SUM(CASE WHEN trnansactionCode = 10 then b.deposits Else 0 END)...

Select a.account, a.cash, deposits1 = SUM(CASE WHEN trnansactionCode = 5 then b.deposits Else 0 END) deposits2 = SUM(CASE WHEN trnansactionCode = 10 then b.deposits Else 0 END) From table_a a Join table_b b ON a.account =...

youre not supposed to sum the cash...group by acct and cash from table a