What settings do I have to change to get msmerge_tombstone and msmerge_contents to be cleaned up more frequently?
The size of these tables are getting silly and I don't even know what they do.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23027240.html
Hello,
I installed MSDE 2000 in my pc, since my pc o.s. is windows xp, so only the client mode can be installed into my pc (Enterprise Manager and some other tools are installed) ( MSDE 2000 is ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23037274.html
Does anyone have a query that will use the sysJobSchedules table in MS SQL 2000 to create a result set that will give me all the expected run times of a job for a given date range?
For example ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23119410.html
I can't use neither xp_cmdshell nor isql/osql
have an .sql file that is creating some tables/indexes/preloaded data, etc on diff DBs in the same ms-sql server.
So I have this script that runs fro...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23149615.html
Hi,
I have the following fields ( Attach Code Snippet )
I need to know how many members select DeviceNameID = 1 and how many members select DeviceNameID =2 and so on.
means the DeviceNameID w...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23298917.html
I have a database that I wish to make a copy of. Is there any way of doing this via SQL Server Enterprise Manager?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23306355.html
Hi,
I have 6 year of historical data for web site statistics : visitor count, new users ( registerd user) , visitor from partner.
We need to know the estimated new users for next day only ( 1 day...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23315750.html
I have a JOIN which I believe is fine. One table has the agent name, calls recieved and extension. The second table has the date, extension and sales total.
I am trying to join the two tables ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23352160.html
I have two tables, described below:
tblAgentCalls has Agent, Date, CallsTaken
tblAttendance has Agent, Date, Reason - this will store the reason they are absent for that day (sick/vacation)
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23354233.html
There is a view which pulls from a table joining on another view. That other view is pulling from the same table. There are two view like this - one view will pull 155K rows, the other only 4K. ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23362826.html
