| Thread | Last Post | Replies |
|
| print number of update records through sql job | 03 Sep 2010 03:47 GMT | - |
I have update statement which updates column name (auditor_details) in a churn of 5000 records at a time of auditor table which contain 3.2 millions records. I have schedule this through sqljob. I'm looking over sql example to check for update records and gives a output and quit ...
|
| Granting rights to backup program | 02 Sep 2010 16:44 GMT | - |
What Sql Server rights are typically given to a backup program that backs up the entire server? Sysadmin works obviously, but that seems like the rights are excessive. Any help will be appreciated.
|
| query doesn't complete - Pls help | 02 Sep 2010 14:38 GMT | - |
Hi, the following query which has been used many times before, just never seems to complete this time. Other than a table name, nothing has changed. The table being updated has 16 million rows and the other views used in the select have 216 and 360 million rows.
|
| Add Column / Drop Column Not Replicating in Subscription | 01 Sep 2010 12:56 GMT | - |
Dear Sir, I have created one publication & created one subscription for one database. If I Add / Modify / Delete any records at Publisher or Subscriber level it replicated in both database properly while synchronize it.
|
| help with sq | 30 Aug 2010 00:44 GMT | - |
|
| Energy Saving Tips | 29 Aug 2010 22:11 GMT | - |
1. Reduce heater's room temperature For each extra degree (Celsius) of temperature, your heater will consume 7 to 11% more energy. Adjust it to 18degrees which is also better for your
|
| um schnell geld , wie kann ich schnell geld machen , am meisten geld machen , schnell legal an geld , jetzt sofort schnell geld gewinnen , hold em poker online spielen , kostenloses gewinnspiel , schnell geld machen in , geld verdienen mit , geld | 27 Aug 2010 17:14 GMT | - |
um schnell geld , wie kann ich schnell geld machen , am meisten geld machen , schnell legal an geld , jetzt sofort schnell geld gewinnen , hold em poker online spielen , kostenloses gewinnspiel , schnell geld machen in , geld verdienen mit , geld verdienen durch internet ,
|
| cleare space using shrink | 25 Aug 2010 09:59 GMT | - |
I have server which has not enough disk space. I have removed an unessesery data from my databases which is approx 50% of the datbase which is 20 GB As i know i need at least 20 GB on the HDisk to run the shrink (which i
|
| SMO ScriptingOptions ScriptBatchTerminator doesn't work? | 24 Aug 2010 21:16 GMT | - |
I'm trying to generate T-SQL script for tables, views, etc. in a SQL2008 database using SMO script methods. I'm setting the ScriptingOptions object's ScriptBatchTerminator = true; and BatchSize = 1, but the generate script has no GO commands inserted.
|
| network traffic encryption | 24 Aug 2010 07:59 GMT | - |
I want to encrypt database traffic to an MSSQL 2000 server. At the server (Win 2003 server sp2), using the SQL Server Network Utility, the only enabled protocol is TCP/IP. Force protocol encryption is checked. The server does have a certificate, issued by
|
| help for query require | 21 Aug 2010 15:10 GMT | - |
I have reqiured a query which extract data from the table which is based on max date & time and today date,please hel p me Tablename xyz S.no Symbol Date &time Opening rate Current rate
|
| Query TableName stored in another table | 20 Aug 2010 03:54 GMT | - |
History: Currently I have an sProc that returns a row of data for my data entry process, first retrieving the tablename then querying it; however I'm now writing a webpage admin UI for near-novice users and will not be exposing the sProc as it would take too much to explain how ...
|
| SSIS 2005 logging in BIDS and under scheduler | 19 Aug 2010 18:16 GMT | - |
I have a package that is working and logging correctly under BIDS 2005 (SS 2005). It logs what I want (in particular "Information" log messages) to a text file. But when I run the package under the scheduler, all it logs to the text file is "Package Started" and
|
| online kredit test , banken kredit , schufa freie kredite , credit online , kredit fuer beamte , girokonto online , kredit umschuldung , sofortkredite , bon kredit ciao , hat erfahrung mit bon kredit , + + + +++ GUENSTIGE KREDITE ONLINE +++ KREDI | 17 Aug 2010 23:33 GMT | - |
online kredit test , banken kredit , schufa freie kredite , credit online , kredit fuer beamte , girokonto online , kredit umschuldung , sofortkredite , bon kredit ciao , hat erfahrung mit bon kredit , +
|
| Question about transactionnel replication | 13 Aug 2010 20:19 GMT | - |
I'm new in Replication word and I have a few questions for you I've setup a transactionnel replication that is working fine, I know that data changes is pushed from Publisher to Subscriber by the Log Reader agent, but how about schema changes? if I alter an exiting article or add ...
|