Viewing 11 posts - 1 through 11 (of 11 total)
Try to add the Access DB as linked Server and compare the table schema.
November 20, 2010 at 9:31 pm
Hi there,
My recommendations are:
1-Check the windows policy (create a Service account with the minimum prev.)
2-Check the Windows NIC card, they need to be in Order. Uninstall IPV6.
3-Check id the SQL...
November 20, 2010 at 9:12 pm
Talk with the developers, Check the Store Procedures,Views, Function and DTS/SSIS if any,
Over the object (Table,View,Etc) Right click-View Dependencies-Objects on Which [xxxx] depends.
November 20, 2010 at 9:05 pm
Hi there.
Turn off the firewall on both the Server/Client Computer and Include in your query EXECUTE AS
and Let me know.
October 7, 2010 at 6:02 am
I use FreeNAS too. with ISCII, FC (Fiber Channel Cables) Method is expensive CZ you need special hardware
May 8, 2010 at 3:47 am
1- Link the server
EXEC sp_addlinkedserver 'OracleSvr',
'Oracle 7.3',
'MSDAORA',
'ORCLDB'
2-SELECT
SELECT *
FROM OPENQUERY(OracleSvr, 'SELECT name, id FROM albert.titles')
3-UPDATE
UPDATE OPENQUERY (OracleSvr, 'SELECT...
May 5, 2010 at 5:08 pm
Try to use a third party software like FreeNAS, Openfiler ,Starwind, ETC
1- Create 5 HD (1-Quorum 1-Dtc 1- SQL Temp Db 1- Log File 1-MDF)
2- Using ISCII , connect...
May 5, 2010 at 12:38 pm
Try this one and let me know.
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'ebayOchkee',
@recipients = 'adventorworks@gmail.com',
@query = ‘SELECT categoryname,brandname,productname,colorname,colorcode,psizename ...
May 5, 2010 at 12:13 pm
I think the Answer is ( 0 ) Bz the field QOTDID don't exist, there no Update.
May 5, 2010 at 11:12 am
Viewing 11 posts - 1 through 11 (of 11 total)