Search results for query: *

Ah, thats going to be a little more tricky then. If you navigate to the Security folder in Management Studio and then to Server Roles and double click 'sysadmin' do you see BUILTIN\Administrators there? MissTipps CISSP, CEH, CEI, MCT, MCDBA, MCSE 2K3, CTT+, ECSA, Security+

And you have, presumably, checked that BUILTIN\Administrators is a member of the System Administrators role? Hmm, you could try connecting to the server as 'sa' to remove the Windows layer from things and see if you can creaet the login that way. MissTipps CISSP, CEH, CEI, MCT, MCDBA, MCSE...

Have you checked whether that 2.1GB of memory that SQL is using is all physical memory and you're not seeing a lot of page file usage? Also out of interest how big is the database on this server? MissTipps CISSP, CEH, CEI, MCT, MCDBA, MCSE 2K3, CTT+, ECSA, Security+

Ok - transaction log 101 (in simple terms) Transaction log exists for two reasons: 1. So that YOU can recover to a point in time if the database gets screwed up 2. So that SQL Server can recover itself should, for example, the service unexpectedly stop for any reason. In Simple recovery...

Is the account you're logging onto the server as a member of the Administrators group on the server? MissTipps CISSP, CEH, CEI, MCT, MCDBA, MCSE 2K3, CTT+, ECSA, Security+

Thanks Mike. It doesn't get to the bottom of the problem, but is basically the way I thought I would have to go with this, i.e. count the number of partitions. MissTipps CISSP, CEH, CEI, MCT, MCDBA, MCSE 2K3, CTT+, ECSA, Security+

You say "..should access.." Have you checked the execution plan to see that the query is actually using the index? MissTipps CISSP, CEH, CEI, MCT, MCDBA, MCSE 2K3, CTT+, ECSA, Security+

What happens if you map that UNC path to a drive letter under that same profile and then use the drive letter in the xcopy command? MissTipps CISSP, CEH, CEI, MCT, MCDBA, MCSE 2K3, CTT+, ECSA, Security+

In short, with SQL Mail, the answer is no. MissTipps CISSP, CEH, CEI, MCT, MCDBA, MCSE 2K3, CTT+, ECSA, Security+

Ok, so I have a stored procedure that 'intelligently' does my DB optimisation. It uses the dm_db_index_physical_stats DMF to populate a table with details of all indexes that need a rebuild/reorg. Then from that it dynamically builds and executes the necessary ALTER INDEX statements. Thats all...

You can do that, but you would need to try and estimate how big the transaction log on your published database is going to grow in that time. MissTipps CISSP, CEH, CEI, MCT, MCDBA, MCSE 2K3, CTT+, ECSA, Security+

Essentially you can't (and the logs will fill up). If you think about what that transactional replication is doing - you are saying "only commit this transaction when I can confirm it is written to both the publishing and subscribing databases". If you aren't writing to the subscriber, then...

This IS the error I received when trying to run a full backup MissTipps CISSP, CEH, CEI, MCT, MCDBA, MCSE 2K3, CTT+, ECSA, Security+

Hi I was just thinking that trying to start the service even in single user mode would probably be bad because it would still fail when trying to bring model online. There is a switch -T3608 which starts SQL Server with minimal configuration and brings only master online, but as its SQL 2005...

Hi I have a database which has started generating the following backup error: Msg 18273, Sev 16, State 1, Line 1 : Could not clear 'DIFFERENTIAL' bitmap in database '' because of error 5242. As a result, the differential or bulk-logged bitmap overstates the amount of change that will occur...

Thanks for that Paul, but our development team is regularly doing this kind of thing - moving DBs from different environments just to get hold of up to date test data. I'm familiar with orphaned users, but this particular error never occurred until after the upgrade, which is why I mentioned...

Hi I just installed SP2 on three of my dev boxes recently and the resulting problems manifested themselves shortly after. 1. This error started to appear in the System Log (several times a minute) - eventually taking down the server: "An I/O operation initiated by the Registry failed...

Hi When you run the DTS package, are you actually executing it on the server or are you running it on your local machine. If so, try checking out the Oracle ODBC/OLEDB driver versions between your local machine and the server. It could be that there's a problem with the version on the server...

Hi I used the Official ISC2 Guide to the CISSP Exam when preparing to sit my CISSP. In addition I also used the Exam Cram book as extra preparation. One really useful resource was the www.cccure.org website. Not sure if you've been using this but it has all kinds of information, study...

Hi When you attempt to run it in Query analyzer, what error do you receive? MissTipps CISSP, CEH, CEI, MCT, MCDBA, MCSE 2K3, CTT+, ECSA, Security+