I have a view that filter a larger table, and I need to build a trigger on this view. I am using Enterprise Manager, and doing it via All Tasks->Manage Triggers...
Problem is when I try to creat...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20265332.html
hi,
i know is something simple but i dont get it why it does not work.
if i create the following view:
CREATE view_1 as
SELECT field1, field2
from FIELDS
go
it creates the view witho...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22143775.html
Our SQL server got a massive lag hit yesterday. I tried tracking the problem to no avail. The only thing I could find was in the server logs, where about 200 log entries read
DBCC TRACEON 208, ser...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10292776.html
OK, the information I had received on my Initial post works fine for a stand alone process -including the file path and the image showing up where it belongs. However, after doing the test, I took...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_20626058.htm...
Zones:
ASPDate Answered: 05/27/2003 Grade: A Views: 0
I try diferent ASP scripts for upload, and some of them give error
Request object error 'ASP 0104 : 80004005'
Operation not Allowed
/clsUpload.asp, line 208
- lnBytes = Request.Binar...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_20884158.htm...
Zones:
ASPDate Answered: 02/16/2004 Grade: A Views: 0
Hello all...
SQL 2000, sp3, Win2K
I have inherited a DTS package that includes a Copy SQL Server Objects task. This task copies all objects and data and has been around for years. It is no...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21428257.html
DECLARE @FileName varchar(200), @bcpCommand varchar(8000)
set @Filename = '\\primaryserver\e\output.txt'
SET @bcpCommand = 'bcp "select top 10 educationnumber from HodderBigSpirit..tblSalesTran...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22014345.html
I get this every 15 minutes:
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 1/3/2007
Time: 4:45:00 PM
User: N/A
Computer: SERVER1
Des...
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/SBS_Small_Business_S...
Hi -
We are using MS SQL 2003 and had a maintainace plan configured to automatically dump the backups of our databases into the specific folder to be backed up. Recently, this automatic back u...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22141350.html
I'm trying the following bcp syntax and get the error listed below:
exec master..xp_cmdshell
'bcp ##wkGSRC out "\\SPSRV\f$\bcptest.csv" -c -t -S SPSRV\SPORTAL -T
SQLState = S0002, NativeErr...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22591099.html
