Viewing 15 posts - 39,361 through 39,375 (of 39,466 total)
You need to change the server name in SQL.
Use sp_dropserver, sp_addserver with the LOCAL option.
Steve Jones
August 20, 2001 at 12:09 pm
August 17, 2001 at 8:41 am
August 15, 2001 at 9:34 am
I had a similar problem. I rebooted the server, then stopped the SQL services and was able to get the script to run.
Steve Jones
August 15, 2001 at 9:33 am
Usually when you connect through a COM object, the object proxies the user account. In other words, the user account is not used to connect to SQL Server, the account...
August 15, 2001 at 9:27 am
Sean Burke wrote an article addressing some things. You can read it here:
http://www.sqlservercentral.com/columnists/sburke/introductiontostoredprocedures.asp
Steve Jones
August 15, 2001 at 7:51 am
When you do the 3 tier, the MTS login must have an account on SQL Server. Have you checked this?
Steve Jones
August 15, 2001 at 7:49 am
Use a tinyint, no nulls.
If you allow nulls, then you have a 3 values field, not 2.
tinyint is the best choice for the reasons outlined by mdburr above.
Steve Jones
August 14, 2001 at 5:25 pm
SMTP is Internet email.
BCP is a utility that ships with SQL Server. It can be distributed to your partner and can run on any windows workstation. The workstation will need...
August 14, 2001 at 5:23 pm
Are the Paradox and FoxPro files on the local server or a remote location?
I see this occasionally. It appears that once the xfer starts, it is very intolerant of network...
August 14, 2001 at 5:17 pm
You could setup a table, give a login/user rights to just this table and let the other company BCP in.
If you do, I'd recommend setting up a field that has...
August 14, 2001 at 11:12 am
The only way would be to have a trigger "send" a message to the app. This may involve a COM type object, but I would recommend against it. If the...
August 14, 2001 at 10:30 am
Lots of debate on this one. Some people think that the data itself should generate the primary key.
I like to use identities, but they are problematic when moving data from...
August 14, 2001 at 10:28 am
I ran this:
create table Logins
(
LoginID varchar(8),
[Password] varchar (8)
)
go
insert logins select 'Bill', 'Gates'
insert logins select 'Tick', 'Tick123'
go
select * from logins
go
select * from logins where loginid='Bill' and [Password]=ENCRYPT('GATES')
go
drop table Logins
No rows returned...
August 14, 2001 at 9:54 am
Noel,
Outstanding!!!! I didn't know this.
Thanks for the info.
Are you interested in writing a short "Transferring System Tables" article? If not I will, but it's a great topic.
Steve Jones
August 13, 2001 at 2:14 pm
Viewing 15 posts - 39,361 through 39,375 (of 39,466 total)