have ame in one of my non prod environments.

http://support.microsoft.com/kb/933835

Error message when an SSIS package runs that is scheduled to run as a SQL Server Agent job: "An OLE...

Funny or not. I used these questions interviewing people for the job (production dba that is). For fun at first... Honestly I had to 'lower down' my usual questions set,...

Brandie Tarvin (10/3/2007)

---

Liliya,

None of the local department ITS support groups in my workplace have actually been asked for Active Directory or Windows Groups lists. Usually, the auditors go to...

Sure can do so. It all depends on what a company can get away with.

If the database is ms sql it is possible to fails on SOX as long as...

there is a legitimate request: provide all the individuals/services/applications that have access...

actually auditors ask for the content of domain groups in sql for financial databases. keep it in mind and make yourself nice useful script that will pull groups you have...

not the best question and the bad answer was selected as the correct one.

It is a small part of a big upgrade, and not for admins only.

DMX can...

not exactly correct question and the answer.

sysadmin, db_owner and db_backupoperator will have the rights, so the only answer between the 4 is correct, because 'there is a way to check'....

get this from profiler. Is it a question from non enterprise environment where everybody can suggest to change source code? Not a good answer, do not teach developers to work...

-c -m works. used on routine bases during DR. production servers have 8gb+ memory, DR all 4GB.

cd C:\Program Files\Microsoft SQL Server\MSSQL\Binn

sqlservr.exe -c -m

starts the server just fine with...

there is a way to shrink the log without truncating (busting LSN's). Easy enough, but can be done manually.

Depends on how active your database is and how soon the transactions...

http://msdn2.microsoft.com/en-us/library/223c3a59-84c3-4f60-be98-a8daf69e9473(SQL.90).aspx

how to set up SSIS on a cluster. works just fine.

yep, I forgot to mention that one too. my stuff is taken with sa rights, so I'll pull all available data

new server is one of 3

you have a new subscriber

you have a new publisher

you have a new distributor

and what do your logs say in all 4 cases...

question: does you new server see your old server, because if it does, then I do not recommend doing operations like sp_dropdistributor, because it points at you real production is...