I just reread the licensing for SQL Server 2005.  You would need to purchase a per processor license for each processor in the server.  If you are looking at a...

Try the following:

declare @d1 datetime,

        @d2 datetime

set @d1 = cast('2007-01-12 15:01:50.863' as datetime)

set @d2 = cast('18:00:00.000 as datetime)

select datediff(ss, @d2, cast(convert(varchar(12), @d1, 114) as datetime)/3600.0

hth

I can't directly answer your question, but I do have a question for you, how many users access the system?  You indicate it is low use, so why are you...

IIS needs to be installed on the same system that you install Reporting Services.

Two questions come to mind.  First, when you say there is a 30 second delay, are you saying it takes 30 seconds for query window to return from executing xp_cmdshell? ...

It may not be blocked, but if there are a lot of locks issued, the Current Activity screen can hang and eventually timeout.

Load the new file into a temp table, then use a query to select the data that needs to be loaded based on the primary key of the data.

The only time I would not use aliases for column names is in queries selecting from a single table.  Once you start joining tables, it makes sense to alias the...

Best suggestion I can give, and that I have seen from others on this site, is test, test, and test some more.  You will find that some times the EXISTS...

You can use it, it just won't return a sorted result set if the order by is included in the view declaration.  A view is a table and SQL (not...

The TS stands for Technology Specialist and PRO for Professional.

hth.

I have used EXISTS in queries, but I have found that in many cases an inner join actually worked better than the EXISTS.  It really depends on the queries you...

Best way to think about it is this: It acts like a cursor, and you have them nested, each of the 600K rows has the potential of running through all...

It would help to see the DDL for the table(s) and what you have currently tried to do to solve your problem so far.  There really isn't enough information in...

Not sure, it has been a while since I had this issue, but you may need to reinstall the client tools on the server.  I had this happen at a...