Hi Tom,

first we need to find out what table really causes the problem. Run this script then according to the results we can certainly find the big...

It's related with API repository. BOL ref:

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\repospr.chm::/rrsqlschema_2m79.htm

You are using API's right? I guess the versioning information is stored on that table.

You are welcome, enjoy it.

You can use netsvc if it is installed on your computer.

NETSVC servicename \\computername /command 

   servicename  Name of the service 
   computername Name of the computer to administer. 
  ...

Where I meant to put the isnull clause was the "order by" of your query. I think it won't be too difficult to change only that part. In case I understand...

You can use "isnull(column_name,0)" in the order clause but using a function in the order or join clause kills the indexes you know.

If I didn't understand you wrong you want to make the log file smaller, right. What you need to do is in fact simple.

DUMP TRAN [DB_NAME] WITH NO_LOG

DUMP TRAN [DB_NAME]...

If you get this message after you started the SQL service it indicates that the transactions that are about to commit right when you close down the SQL engine are...

Thanks a lot everybody.

I know what I represented as my table is a bit general but since I wanted to reach a general rule for dividing tables I choose that...

Thanks for replies!

Let me tell you what I'm faced with by making example of it

The table (and some dummy data was like that)

IDColAColBColCColDColE
----------------------------------
1AAABBBCCCDDDEEE
2AAABBBCCCDDDEEE
3AAABBBCCCDDDEEE
4AAABBBCCCDDDEEE
5AAABBBCCCDDDEEE
6AAABBBCCCDDDEEE
7AAABBBCCCDDDEEE

All (or most) of the columns has non-null...

I think I didn't understand your question clearly, "SQL_AltDiction_Cp850_CS_AS" option exists within the drop-down menu so you can select it. Can you describe the problem.

Zubeyir

If you are using SQL 2005 than you do not need to use another thing. But if you are using SQL 2000 you need to use some extended stored procedure...

Shorcut for NULL value is "CTRL+0"

For general shortcut keys look for BOL "shortcut keys" term

Cheers,

Zubeyir

Enjoy it 

Zubeyir

Try to place a trigger on the source table that inserts new rows into the destination table. In order to do this you need to make a linked server connection...