Viewing 15 posts - 2,071 through 2,085 (of 2,387 total)
Are you a member of sysadmin (sa) in SQL Server? Only members of the sysadmin and bulkadmin fixed server roles can execute BULK INSERT.
April 1, 2003 at 2:37 pm
Which service pack and MDAC version do you have for SQL Server? What network (TCP/IP, Named Pipe or MulitiProtocol) library do you configure on both server and client? What type...
March 31, 2003 at 9:44 am
Can you check your server application and system logs for any errors?
March 31, 2003 at 9:28 am
Any errors did you have in SQL Server errorlog?
Any changes implemented to your SQL Server recently? Can you post result of sp_configure
March 31, 2003 at 8:44 am
Can you post the script your DBA is going to implement?
For FK constraint, there are option 'with check' and 'with nocheck', which are used to verify new CHECK or FOREIGN...
March 31, 2003 at 8:38 am
MSDE comes with QA tool OSQL.EXE and use it
1. You can backup database in MSDE A and restore it into MSDE B.
2. Shutdown MSDE and copy MDF and LDF files...
March 31, 2003 at 7:32 am
I don't know whether this analytical tool (Sagent) can transform data to round the decimal number to 1 scale. If it can't, try to load the whole decimal number into...
March 28, 2003 at 9:37 pm
Because you defined only 1 scale for column ([S_Sales_Measure]. Change it to ([S_Sales_Measure] [decimal](10, 5) NULL).
March 28, 2003 at 2:23 pm
Which version of your SQL Server client tools such as QA installed in the client machine that you have such problem? You need SQL Server 2000 version.
SQL Server uses an...
March 28, 2003 at 12:47 pm
In your machine, there is a service called 'sysmonlog', ie performance logs and alerts. You have to change the startup account in this service to a domain account that...
March 28, 2003 at 11:31 am
You can create linked server to your Access database and use "sp_indexes" to list indexes information from ACCESS database into a temp table and write TSQL script to loop this...
March 28, 2003 at 8:38 am
select object_name(ind.id) as TableName, ind.rows as RowCount
from sysindexes ind, sysobjects obj
where (ind.indid = 1 or ind.indid = 0)
and obj.id = ind.id
and obj.xtype = 'U'
order...
March 27, 2003 at 6:48 pm
For security concern, you should apply security patch ms02-061 or service pack 3 if you havn't done it.
March 27, 2003 at 6:32 pm
Performing full database backup does not truncated the transaction log so you are still able to continue the log backup as usual.
March 27, 2003 at 6:22 pm
Viewing 15 posts - 2,071 through 2,085 (of 2,387 total)