hey Gaill

i agree that fixing it to any arbitrary value doesnt solve the issue . i told him to do so because i thought doing this SQL will not...

audiocool (5/18/2015)

---

Hi,

Many thanks for your valuable advise. Could you please guide me through the steps to troubleshoot the problems in my environment. I had around 10 databases with 2...

audiocool (5/18/2015)

---

Hi,

Many thanks for your valuable advise. Could you please guide me through the steps to troubleshoot the problems in my environment. I had around 10 databases with 2...

:cool::hehe:

use the command on that database

sp_change_users_login @Action='Report'

GO

if you got any result those will the users who wont be able to access the database

then fix them with

EXEC sp_change_users_login 'Auto_Fix',...

SQL-DBA-01 (5/14/2015)

---

Hello Experts

I am looking for a script/proc, to extract the error captured in a daily basic for the whole day and report to the DBA over email. Second part...

what you can do is create the trigger which can track the changes in a object and and store the changes in a table and then can copy the...

have you tried this ?

http://tutorials.aspfaq.com/8000xxxxx-errors/why-do-i-get-80040200/80040514/800a0e7a-errors.html

WINNERS NEVER QUIT AND QUITTERS NEVER WIN

sqlserversdba.wordpress.com

hi

if You save that package then it will be saved As SSIS package. but you wont be able to use the same job for different file.

and the next question...

after attaching the database try to check for orphan users

WINNERS NEVER QUIT AND QUITTERS NEVER WIN

it might be helpful ...

Use SSIS to get data in csv or flat file and this is pretty simple or u can use export option also

Open the file...

When I run the "Copy Database Task" on server 1 to server 2 and the server 2 version is newer or equal to the server 1 version it runs fine....

unselect the option of which allows the report to capture the catch copy. this will cause report to run every time with actual data

WINNERS NEVER QUIT AND...

but the most important question will be , IS that fragmentation cost u so anything? is it impacting the performance ? as discussed earlier if the size of the table...

Check If the table your Talking about is contain Primary key/index , if not then plzz create one, so effect of Insert may be reduced for fragmentation..