Viewing 15 posts - 1,726 through 1,740 (of 2,387 total)
Your Access database is password protected, Is it?
May 29, 2003 at 9:19 am
1433 is TCP port and 1434 is the UDP port SQL Server uses. The answer is correct.
May 29, 2003 at 9:11 am
login QA with SQL Server authentication and run your script. If it still doesn't work, run following example.
--Create a temp table to hold
create table #Tables
(
table_cat sysname null,
table_schem sysname null,
table_name...
May 28, 2003 at 6:52 pm
You have to prepare the restoration from full database backup.
Edited by - Allen_Cui on 05/28/2003 2:33:02 PM
May 28, 2003 at 2:23 pm
quote:
I want to turn off the logging only for the few insert statements Im running in this session.
May 28, 2003 at 1:58 pm
Create sp in serverA to select data from remote_server and call the sp from server B, C and D.
create procedure sp2000_helpdb
as
select * from [remote_server].master.dbo.sysdatabase
in server A
exec [server_A].master..sp2000_helpdb
in server B, C,...
May 28, 2003 at 1:17 pm
Any changes made to your job such as service pack, job owner, SQL Agent account/password, permissions if there are commands in the SP that have to access share directory?
May 28, 2003 at 12:05 pm
You can add column at bottom and select them in the sequence as you like.
If you really want to add column in sequence, recreate your table.
Edited by - Allen_Cui...
May 28, 2003 at 11:59 am
Use four-part naming convention. For example,
select * from tstsql01.master.dbo.sysobjects
May 28, 2003 at 11:55 am
What have you done from nightly backup to noon backup? Have you reorganize the database?
May 28, 2003 at 9:53 am
This KB may help.
http://support.microsoft.com/default.aspx?scid=kb;en-us;306649
May 28, 2003 at 9:51 am
Debugging Functionality Changes Introduced in SP3
The functionality for debugging stored procedures with Microsoft Visual Studio® 6.0 and older or with SQL Server Query Analyzer prior to SP3 is turned off...
May 28, 2003 at 9:49 am
You only secifie the maximum total number (3) of decimal digits that can be stored, both to the left and to the right of the decimal point. The maxium number...
May 27, 2003 at 2:53 pm
Viewing 15 posts - 1,726 through 1,740 (of 2,387 total)