I'm not sure I should be offer advice, but in 2000 I would do this:

exec sp_helpconstraint <tablename>

and then for each constraint identified I would issue an...

And I don't have a 6.5 server anymore, and my memory doesn't recall how to do it in 6.5.

I'm sure some other individual will help you out.

One thought...

One method would be to go into EM, hightlight the table, right click and choose "Design Table". Or you could issue the something like:

ALTER TABLE <yourtable> ALTER COLUMN <yourfloatcolumn>...

Maybe. If your float data is less then 6 characters long you should have no problem. Now if it is not, you will need to update all the...

I use a product call SQL Compare by Redgate. Works very good. Think you can get a 15 day evaluation copy of tool here:

http://www.red-gate.com/downloads.htm

Gregory Larsen, DBA

If you looking...

That SP should look something like this:

create procedure usp_test as

declare @cmd varchar(4000)

exec master.dbo.xp_cmdshell 'OSQL -E -h-1 -s "," -Q"set nocount on ; select * from sysobjects "...

Here is a function to ISO Week right from BOL:

CREATE FUNCTION ISOweek (@DATE datetime)

RETURNS int

AS

BEGIN

DECLARE @ISOweek int

SET @ISOweek= DATEPART(wk,@DATE)+1

...

If you have a primary key by design need to be unique, and SQL Server will not allow you to add a duplicate record. If the record is not truly...

So is it my understanding that if you set up a certificate server with SSL then the passwords are not broadcast as clear text, but without certificate server and SSL...

We are not using active directory right now, and I think it will be sometime before we get there.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my...

Are you saying you have set the "Basic Authentication (password is sent in clear text) option in IIS for you intranet applications? If so would this not allow someone...

Try this:

update #stateSummary

set

leadsTotal = count_stateOrProvince

, revenueGross = sum_leadRevenue

, leadDistributed = sum_leadCount

, leadCost =sum_leadRate

from (select stateorprovince, count(stateOrProvince) as count_stateorProvince,

sum(leadRevenue) as sum_leadrevenue,

sum(leadCount) as sum_leadcount,

sum(leadRate) as sum_leadrate from

#leadDistributionSummary

group by

stateOrProvince

)...

You might try using xp_cmdshell to execute a OSQL command. The OSQL command can execute your SP and redirect the output to a file.

Gregory Larsen, DBA

If you looking for...

In our environment we place the developers in the db_owner role. The actual DBO is normally SA, or one of the SYSADMIN users. It is much easier to...

You also could open excel and use the "Get External Data" function to import SQL Server data into excel, but of course this was not what you where asking.

Gregory Larsen,...