Viewing 15 posts - 106 through 120 (of 398 total)
Use ISQLW with -C option instead of osql.
February 28, 2005 at 4:10 pm
One of reasons could be record is not unique.
February 28, 2005 at 3:21 pm
select name, object_name(parent_obj) from sysobjects where xtype = 'tr'
February 27, 2005 at 10:45 pm
check sqlserveragent startup account, which is responsible for scheduled job.
February 27, 2005 at 10:32 pm
try to change -w value, like -w4000
February 27, 2005 at 10:29 pm
Dictionary order, case-sensitive, for use with 1252 character set.
February 24, 2005 at 5:50 pm
Check default database for the login.
February 24, 2005 at 5:30 pm
Rule acts on the event of insert and update while computed column can not be targeted in either.
February 24, 2005 at 5:27 pm
Backup FUR_ACCT from FURSQL and restore it to FURTEMP.
Check BOL(Book onLine) for detail.
February 24, 2005 at 4:47 pm
SQL Enterprise Manager, Select database, on Action menu, select All tasks, Generate SQL Script.
February 23, 2005 at 4:37 pm
It worked for me sometime ago.
My test indicates connection string may be the problem.
Try simplify it with
FROM OPENROWSET('SQLOLEDB','1.1.1.1,1433';'user';'pw','SELECT * FROM dbname..tablename')
February 23, 2005 at 4:30 pm
select object_name(a.id) table_name, a.name, b.collation
from syscolumns a inner join systypes b on a.xusertype = b.xusertype
where a.collationid = b.collationid
and not exists(select * from sysobjects c where a.id = c.id and c.xtype...
February 23, 2005 at 1:14 am
Viewing 15 posts - 106 through 120 (of 398 total)