Hi

Have you tried Dave's blog?

http://blog.sqlauthority.com/2008/05/06/sql-server-2005-fix-error-18456-vista-windows-authentication/

Hi

Firstly you will need to create a linked server (if you already haven't).

Then follow the blog below.

http://blogs.msdn.com/joaquinv/archive/2008/10/23/execute-oracle-stored-procedure-in-sql-server.aspx

Have you tried the OPENQUERY statement?

delete

openquery(Linkedservername, 'select ......... from tablename where ....')

Not sure this is the ideal way, but there safest in our company is...

- Remove replication on the DB you want to restore and on the subscribers.

- Restore the DB...

Look @ BOL and search for "SET Options That Affect Results"

Its is under Indexes | Designing Indexes | Gernal Index Design Guidelines.

Some good tips in there.

As Lynn as already posted, use the import/exp wizard.

Below is a good article with print screens.

http://www.databasejournal.com/features/mssql/article.php/3580216/SQL-Server-2005-Import--Export-Wizard.htm

Hey

http://sqlblog.com/blogs/kalen_delaney/archive/2009/05/03/controlling-lock-granularity.aspx

At the bottom of the blog gives you some info on the questions you have asked. Keep the blogger bookmark.. He writes some good stuff

JL

Not sure how to do it in Java

But I would make the SP output a return value instead of print.

CREATE PROC p_ReturnValue

@ReturnValue INT output

AS

SET @ReturnValue = 999

RETURN @ReturnValue

declare @returnvalue...

Have you looked at the MS Article?

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

I would personally start with why you are getting blocking...?

1. What hardware does the SQL server run on and is it enough?

2. Check for "missing" indexes. The script attached uses...

I dont suppose you have checked the blog below out?

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/b5d48c3d-65b6-401d-8b21-5e127faeb5f1/

I too have been bitten with DNS and Clustering!

will you company not allow you to trace the db? you dont need sysadmin right to trace.

GRANT ALTER TRACE TO [domain]\[username];

GO

Or

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47384

Hey

There are a few tip on the link below

http://blogs.msdn.com/sqlserverfaq/archive/2009/06/01/size-of-the-transaction-log-increasing-and-cannot-be-truncated-or-shrinked-due-to-snapshot-replication.aspx

If in doubt Wiki it..

http://en.wikipedia.org/wiki/Enterprise_resource_planning

http://en.wikipedia.org/wiki/ACL_(software)

Sample Trigger i use

IF(UPDATE(Authorised))

BEGIN

UPDATE

tbl

SET

IsAuthorised = (CASE WHEN inst.Authorised = 'Yes' THEN 1 ELSE 0 END)

FROM

TABLE tbl

INNER JOIN INSERTED inst ON tbl.TaskNumber = inst.TaskNumber

END