Viewing 15 posts - 2,206 through 2,220 (of 2,387 total)
create table #NTVars (Varable varchar(255))
insert into #NTVars EXEC master..xp_cmdshell 'set'
select * from #NTVars
drop table #NTVars
February 14, 2003 at 9:24 am
Use xp_cmdshell 'set' in T-SQL to output NT environment variables to a temp table and go from there.
February 14, 2003 at 9:11 am
It looks the collation of SQL Server 2000 and the database are different.
February 14, 2003 at 7:49 am
Check registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo\DSQuery value to "DBNETLIB" exists.
TCP/IP has to be enabled in Client Network Utility in Server too.
Which MDAC version in your server?
Edited by - Allen_Cui on 02/13/2003 ...
February 13, 2003 at 3:08 pm
Use server network utility to verify TCP/IP is enabled.
February 13, 2003 at 2:41 pm
Try to add "BUILTIN\Administrators" back to your SQL Server logins with 'sa' right.
Edited by - Allen_Cui on 02/13/2003 1:27:38 PM
February 13, 2003 at 1:27 pm
select obj.name as TableName, sum(col.length) as RecordLength
from syscolumns col
inner join sysobjects obj
on obj.xtype = 'U'
and obj.id = col.id
group...
February 13, 2003 at 10:12 am
Use client network utility to configure your machine to listen to the port number the firewall administrator assign to you.
I don't know how ColdFusion connects to database but you may...
February 13, 2003 at 9:47 am
What kind resources you are thinking there are the bottle neck to you? Create separate file group on same RAID 5 may not help you in your situation.
I would...
February 13, 2003 at 8:36 am
Don't think you can change the service account from local system account to anyone else.
February 13, 2003 at 8:18 am
When you create the maintenance plan for database backup, go to the complete backup tab, choose the disk as backup media and use UNC path as backup directory (For example,...
February 12, 2003 at 12:47 pm
Check this KB from Microsoft.
http://support.microsoft.com/default.aspx?scid=kb;en-us;811031
February 12, 2003 at 8:52 am
No, There is no modified date unless you drop and re-create the sp.
February 12, 2003 at 8:37 am
You may put change control in place for any this kind of changes.
Or write a script and schedule it run regularly to refresh all your views.
February 12, 2003 at 8:32 am
Are the account you used to test same as the account to run the job?
Can you try to run xp_sendmail with a local query?
What kind of linked server in remote?...
February 12, 2003 at 8:05 am
Viewing 15 posts - 2,206 through 2,220 (of 2,387 total)