Viewing 15 posts - 196 through 210 (of 920 total)
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)
October 24, 2012 at 1:56 pm
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...
October 24, 2012 at 9:13 am
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...
October 23, 2012 at 5:06 pm
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...
October 23, 2012 at 5:02 pm
select * from sometable where cast(datetime_column as time) = '00:00:22:000'
October 23, 2012 at 2:33 pm
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...
October 23, 2012 at 9:17 am
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...
October 22, 2012 at 10:42 am
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...
October 22, 2012 at 9:50 am
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...
October 22, 2012 at 9:37 am
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...
October 19, 2012 at 12:10 pm
You need to add the 'group by CAP' and remove the 'distinct'.
October 19, 2012 at 11:36 am
You might need to specify the server as:
computername\ABCCOMPANYSERVERSQL
in the -S parameter.
October 17, 2012 at 9:04 am
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...
October 16, 2012 at 3:08 pm
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...
October 16, 2012 at 2:40 pm
Viewing 15 posts - 196 through 210 (of 920 total)