"This is a poor question" OK, well, thanks for the skewer. I'll think twice about posting a question from now on. ;-/ I represented it as I found it, did look in BOL, and did not find anything to contradict the author's comment. I have experimented with it as a feature, and have found that […]
Following up on a question posted in our discussion area, Andy looks at how to use DMO to add and remove linked servers. Along the way he points out a couple 'gotchas' and throws in a cool tip about how to save a little time when you experiment with DMO.
Middle tier applications often use a single database management system (DBMS) to store data, which can expose scaling limitations as the number of user requests increases. Caching, a technique used to increase application performance by copying data and then using the copied data in place of the original data, can dramatically increase the throughput (the number of application requests serviceable per unit time) and scalability of middle tier applications.
I am trying replication in sqlserver 7. My source db has table owners different to dbo. When I trying replication, it searches for tables in the destination server as dbo and not as the owner which is there in the source db. For example in source db has db1.system.emp_master but it tries replication with db2.dbo.emp_master […]
hi can anyone help. I am new to the SQL Server. I need to input data into a column with the PK (Primary Column) From other 2 tables I am using a stored procedure to store the data. Table1 NameID FirstName LastName 1 Sam Smallwood Table2 ID NamesofCD 1 CD1 2 CD2 Table3 NameID ID […]
Log file creation differs between DTS and VB Module? Why? I created a DTS package in SQL-2000 with Win2k server. I saved the same DTS package as VB module. Then i tried to execute the same thro' VB. It is running fine in both the ways. It is creating a log file in dtssteplog table […]