It uses system stored procedures, and in the Replication databases it keeps track of the transactions sent. Are you trying to do something specific, or were you just curious? Or are...

Do a search on this site for Space used. there are quite a few articles, and scripts to help do your work.

This is the first to show in articles. It...

Windows authentication on a sql server will only recognize domain accounts, or local machine accounts (local to the sql server). The local account on your computer will not be recognized.

You...

Yeah, I've never really searched for one. I've usually had other options

check out this thread

it has a link with a function that should do the trick

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=151824

Well, that was an initial guess, it should update okay. but.

Question are the customer records from a different table?, on the same database, different database, and same server or different...

Try a backup and restore.

Back up the existing database to disk.

Copy the backup file to your machine, and restore it locally.

You should be able to use Enterprise manager to do...

If you really, really have to have the commas in the value coming out of sql server your going to cause extra work for yourself.

No numeric values are returned from...

I do this quite often. For your primary step you can simply pump the data in the main table. For the second step pump the rows in a separate Temprary...

It should work. In your example I found 2 errors.

Missing apostrophe before the is in the where clause and is not isnull is not correct syntax should just be just...

Not until you go through and remove all the trailing spaces from all the records that are < 20 chars long.

That could take some time. But new records will not...

Without data, Table structures, and what you think the value should be it is impossible to "Guess" what the problem could be.

http://http://www.aspfaq.com/etiquette.asp?id=5006

declare @cmd  nvarchar(50)

 declare @retType nvarchar(50)

 declare @userdb  nvarchar(50)

 declare @retVal  nvarchar(20)

 set @userdb = 'Northwind'

 set @retType =  N'@filename nvarchar(50) OUTPUT'

 set @cmd = N'use ' + @userdb + ' select @retVal =  file_name(1)'

 exec...

you don't need to cross post. people usally follow items in all forums

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=264864

Try the case statement

rount(SUm((rcitem.fqtrecv- case when dt.qtyfail is null then 0 else dt.qtyfail end) * rcitem.fucost),0)

Not tested

declare @number bigint

set @number = 12345678911

select right(convert(char(11),@number),2)