hi!

look at

http://www.sqlservercentral.com/scripts/contributions/246.asp

best regards

hi yogiberr!

the thing you're talking about is named "database dictionary" (take a look at BOL). for a glance of what information is "hidden" there, look at

http://www.sqlservercentral.com/scripts/contributions/246.asp

regards,

chris.

hi!

have to add something to andy's posting: changes to stored procedures are not replicated withing merge replication, but within transactional replication (sql server 2000).

best regards,

chris.

hi!

it is possible (limitations already posted), but you should just avoid it due to performance reasons! you see, T-SQL is a very limited language and just not built for complex...

hi!

did something similar for a sort of corporate directory application and used a desigen quite common in OOP: put up a master table for all different sort of "contacts" containing...

btw:

for nt4 (if you're still using it) there's no graphical "task scheduler", but a service and a command line statement called "at" ... schedules just fine once you're used to...

look at

http://www.sqlservercentral.com/scripts/contributions/246.asp

select statements 4, 5, 7 of the script will give you all primary keys, unique keys and other indexes alongside with their respective fields.

best regards,

chris.

hi!

you can check the state of ADO connections/recordsets/commands to see what ADO does if you executed a statement asynchronously (this usually requires the adAsyncExecute constant to be used, eg. in...

hi!

you might want to have a look at

http://www.sqlservercentral.com/scripts/contributions/246.asp

to get comprehensive information ...

best regards,

chris.

hi!

sorry, but why *the hell* are you doing this? if you want to import data, why not use DTS? sorry if i got you wrong completely and didn't understand your...

hi!

read carefully: "table" is a reserved word ... "table1" isn't! 😉

best regards,

chris.

hi!

this looks like a timeout or something similar within the NETx subsystem of oracle.

1st step: get your oracle handbook and check the ORA-xxxxx numbers of your errors! could have something...

Just wanted to add something regarding recompilation of stored procedures:

If your data changes heavily and you've got a lot of rows, recreating statistics could change your access plan. In that...

hi!

ADO is showing a quite strange behavior sometimes when it comes to reserved words of the target DBMS.

To avoid any problems like these use something like:

SELECT id, price AS item_price...

something really dirty 😉 would be:

use xp_xmdshell to execute osql.exe which in turn runs your script ...

(don't try this at home)

best regards,

chris.