Viewing 15 posts - 406 through 420 (of 485 total)
You can either change the owner of the object to you user. Create a role and add that user to it and change the owner of the object to role....
October 21, 2002 at 5:30 am
For the complete story look up "I/O Architecture" in BOL and the associated pages.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
October 21, 2002 at 5:15 am
You could do this with a piece of SQL
i.e.
UPDATE t2
SET t2.col1 = t1.col1
FROM table2 t2
JOIN table1 t1 on t2.pk = t1.pk
WHERE t1.col1 <> t2.col1
You will need to use ISNULL...
October 21, 2002 at 5:09 am
What sort of task are you using. Try looking on http://www.sqldts.com
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
October 21, 2002 at 5:07 am
It always seems to be accounts. You have to be logged on as user account that as permissions to create the debugger on the server, the sql server needs to...
October 21, 2002 at 5:05 am
identity_insert allows you to specify the identity value yourself rather than have it generated for you, i.e if your excel spreadsheet has values for the column
Simon Sabin
Co-author of SQL Server...
October 21, 2002 at 5:00 am
Further to that you shouldpass your variables in using sp_executesql
i.e
declare @sql nvarchar(100)
set @sql = 'UPDATE tablename SET ' + @inputvar + '= @somevalue
WHERE condition'
exec sp_executesql @sql, N'@somevalue int', @somevalue
This ensures...
October 21, 2002 at 4:51 am
I agree.
Essentially if you want to know which is better you need to define what you need the db to do and do lots posting. You also have to consider...
October 21, 2002 at 4:49 am
You can also write this as
select claim_number
from history h
left join member m on m.member_id = h.member_id
where plan_id='MTA' and
AND m.member_id is null
if member_id is the pk of member.
Generally sub...
October 21, 2002 at 4:45 am
You cannot just issue an alter table statement. You can change the filegroup in the enterprise manager, right click on the table and select design table.
This can do the change...
October 21, 2002 at 4:30 am
You can set this in the connection string use the APP keyword i.e
"DRIVER=MSDQSQL;SERVER=(local);UID=sa;PWD=;APP=My application"
Have a look at SQLDriverConnect in BOL
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
October 21, 2002 at 4:07 am
sqldts.com has a page that details the options
http://www.sqldts.com/default.aspx?6,105,204,0,1
You could just backup and restore msdb, this should copy all jobs, maintenance plans and dts packages. This might be a problem if...
October 21, 2002 at 4:00 am
IO is in terms of pages which in SQL 2000 are 8k in size.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
October 21, 2002 at 3:53 am
If you are using SQL 7 and triggers be careful, as you the identity gets over written
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
October 18, 2002 at 10:07 am
Viewing 15 posts - 406 through 420 (of 485 total)