Data mining is good way to check the data especially in data warehouse.  However now we have SOX, HIPPA and identity threft, the data security dept (or whatever they call...

Instead of using backup and restore, you can script the database. In the options page, you can script the database, users and database roles, SQL Server Logins and object level...

I just answered the question in the other thread.  I did the same thing.

SELECT COUNT(*) FROM LinkedServer.LinkDB.dbo.Table

It gave me a big number.

Then I did

SELECT COUNT(*) FROM (SELECT TOP 10...

I did the same experiment.

The first one I got a big number.

The second one I got 10.

What is the salary range?

Actually I made it too complicated.

SELECT MAX(RecordID), ProjectID

FROM Temp

WHERE StartDate < DATEADD(MM, -6, GETDATE()) AND

 EndDate < DATEADD(MM, -6, GETDATE())

GROUP BY ProjectID

I changed the query.

SELECT MAX(t.RecordID), t.ProjectID

FROM #Temp t

 INNER JOIN (SELECT Distinct RecordID, ProjectID

   FROM #Temp

   WHERE StartDate < DATEADD(MM, -6, GETDATE()) AND

         EndDate < DATEADD(MM, -6, GETDATE())) d

   ON t.ProjectID =...

I made a mistake about the 5.  But for projectID 2000, you should get 4 as the recordID since the startdate and enddate is 6 month from today.

You are not alone.  How big is your company and how many people in the IT department?  In my company, we have Oracle, SQL Server, UNIX, AS400 and Window NT.  We...

In the DTS Package, which task did you use ? Did you remember to put in the connection?

If you wanted to exec the procedure, it seemed to me the procedure...

In your example, did you miss something?  First you mention there is a field status but there is no status in your example.

You want to write a query of the...

I think you should

Create trigger [dbo].[MPI_Insertordxshopevent] ON [dbo].[bvc_Order]

FOR insert

Then the trigger will happen when you insert into the table.  Then when...

Are you running these command in Query analyzer or in a stored procedure or using DTS package?

Oracle DBA is very different from SQL Server DBA. It is not very user friendly.  Also is your company using Oracle with their ERP system ?  Which version of Oracle do you use? ...

I am a SQL Server developers, right now working on building data warehouse, doing database design and modeling.   In this website, the job post always looks for DBA.  I know...