Probably a better way, but this works:

declare @y int

set @y = 35959

select convert(varchar(20),convert(time,(substring((right(('0' + convert(varchar(6),@y)),6)),1,2) + ':' +

substring((right(('0' + convert(varchar(6),@y)),6)),3,2) + ':' +

substring((right(('0' + convert(varchar(6),@y)),6)),5,2))),100)

Regardless of whether the data is retrieved from the loopback server or directly, the id that gets the data has to have access to that database. You can map...

But if you add the user in both databases, and the databases are on the same server, why do you need a linked server? Why not just use 3...

It would help if you posted the DDL for the tables, with indexes and the actual execution plan of the update. Without those, the information you get back might...

Could be. I'm uncertain...

select * from sometable where cast(datetime_column as time) = '00:00:22:000'

Is this actually a SQL Server 6.5 database? If it is, you might try creating a database with the same file names, shutting down the server, replacing the created...

You'd be wise to listen to Gail on this. If the problem is space on the backup drive, get more space or move some of the older backups to...

People spend years studying this topic and you don't get good at it overnight. There are basic rules you can learn from books and there are lots of different...

Your connection puts you into the master database by default. It looks like the files you are attempting to work with are in another database. Your connection needs...

I have to agree that this is a bad idea. Limited and hard to work with, but this will generate the combinations.

create table #x (letter char(1) not null)

insert #x...

You need to add the 'group by CAP' and remove the 'distinct'.

You might need to specify the server as:

computername\ABCCOMPANYSERVERSQL

in the -S parameter.

Why 3 separate config files? Why not 1 xml config with:

database name

include or exclude (have to figure out what to do if you find a db on the server...

OK, so it looks like it's trying to get a named pipes connection. You need to have the dba make sure that the named pipes protocol is enabled, using...