Even if I selected the "correct answer" (and I got the points...), I'm not so sure about this one. The following page says that you can backup to a local...

Undocumented, but it should work:

CREATE DATABASE NewDatabase
EXEC sp_MSforeachtable 'IF (SELECT COUNT(*) FROM ?)>0 SELECT TOP 100 * INTO NewDatabase.? FROM ?'

Razvan

I think you need something like:

SELECT * FROM ActualNumbers 
WHERE [month]=MONTH(GETDATE()) AND [year]=YEAR(GETDATE())
UNION ALL

SELECT * FROM MonthlyNumbers 
WHERE [month]<MONTH(GETDATE()) AND [year]=YEAR(GETDATE())
UNION ALL
SELECT * FROM YearlyNumbers 
WHERE [month]>MONTH(GETDATE()) AND...

The query optimizer uses one of the three join methods (nested loops, merge, hash), based on the estimated number of records that will be selected and other informations from the...

Mike, use the following query:

SELECT a.name 
FROM person a 
INNER JOIN personproperty b ON a.Personid = b.Personid
INNER JOIN property c ON b.Propertyid = c.Propertyid
WHERE c.Propertyid in (2,6,9)
GROUP...

Indeed, the "correct answer" is wrong.

This registry key is documented in the following KB articles: 827422, 285097, 322336, 325022, 319930. They all say that the registry key for the default...

See http://tinyurl.com/5dbbg

He says that you should mark the error 1205 as logged (by default it's not logged) and restart SQL Server after setting up the alert. Let me know...

Your example is not very good, because the result is the same if you want to round the number to 2 decimals or truncate it to 2 decimals. So let's...

Try the following (not tested):

SELECT * FROM OPENQUERY (MyServer, 'TRUNCATE TABLE MyStage.dbo.MyMemberStage SELECT ''Done''')

Razvan

You cannot do this. All the SQL Server statements run on the server. The backup file will be written on the server, unless you specify a path to a shared...

See my response for the following message:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=124444

You can use sp_dbcmptlevel to simulate the SQL Server 7 behaviour, but this will prevent you from using SQL Server 2000-specific features (for example: UDF-s,...

Federico,

Read the following article by Erland Sommarskog, SQL Server MVP:

http://www.sommarskog.se/dyn-search.html

It's an in-depth article about this problem, with many solutions (using Dynamic SQL or Static SQL).

Razvan

If there are certain status columns that are used in all the queries, try to make a compound index on all the status columns, placing the frequently used columns first....

Stewart, here is a better (easier) way:

WHERE StartDate < DATEADD(m, DATEDIFF(m, 0, GETDATE()), 0)

Razvan

Another way (more clear, but probably slower), could be:

WHERE MONTH(MyDate)<MONTH(GetDate()) AND YEAR(MyDate)=YEAR(GetDate()) OR YEAR(MyDate)<YEAR(GetDate())

I think Stewart's solution is the best, but it works correctly only if there is no time portion...