Hi littlesquall,

You want one line in the output. It means you want each 150 fields in one line, or something else.

I think the line length of the text file is...

Hi,

As GilaMonster said, there a lot processes you can only do with DBCC commands.

I know that Some actions that in earlier releases require DBCC options are performed by ALTER....

Thanks Vidas for sharing the info.

Ahmed

Hi,

The best and the fast solution is using DTS.

DTS tutorial

The best site for DTS and SSIS is http://www.sqldts.com/

http://www.verio.com/support/documents/view_article.cfm?doc_id=3846

Regards,

Ahmed

Hi Carl,

I already redirect the result to file using osql (whithin a stored proc and xp_cmdshell ) or using sp_OACreate 'Scripting.FileSystemObject' and it works fine.

The problem is littlesquall can...

Hi,

You can use xp_cmdshell to execute from a stored proc

Exec master..xp_cmdshell 'osql -E -d NOMADE -S (local) -Q ''select * from MyTable where ...'' -o C:\File.txt'

Hi,

Just I found a good link http://blogs.technet.com/askperf/archive/2007/05/18/sql-and-the-working-set.aspx

Regards,

Ahmed

Yes, you are rigth on this point 'dynamic sql is not precomplied'

Ahmed

Sorry Suresh,

But if you will have more than 4 clients, will you still using conditional execution.

Good luck

Regards,

Ahmed

Hi,

If you see in the maintenance plan, Microsoft does things in the following order

1- Reindex

2- Check DB integrity

3- Backup DB

Regards,

Ahmed

Hi,

I think you can use dynamic SQL

alter proc Test_SP

@dbName Sysname

As

Declare @strSQL Nvarchar(200)

set @strSQL ='Select * FROM ' + @dbName + '.dbo.orders'

exec sp_executesql @strsql

Go

Regards,

Ahmed

Hi,

Check this link http://www.sqlteam.com/article/osql-storing-result-of-a-stored-procedure-in-a-file

Regards,

Ahmed

Hi,

Check the following links

http://www.webservertalk.com/message360107.html

http://www.lazydba.com/sql/1__7186.html

http://www.mydatabasesupport.com/forums/ms-sqlserver/232192-repeated-login-failed-user-sa-entries-sql-server-log.html

Regards,

Ahmed

Hi,

Declare @dbid as int

set @dbid=db_id('northwind')

SELECT

object_name(i.object_id) object_name

,i.name index_name

,i.index_id index_id

,i.type_desc type_desc

,c.index_columns

FROM

sys.indexes i LEFT OUTER JOIN

...

Hi,

Yes when rebuilding the master (Rebuildm.exe), you can change the collation.

Check the following link http://64.233.169.104/search?q=cache:F-uCxqBvvMMJ:searchwinit.techtarget.com/searchwin2000/downloads/pdfs/sqlServerBackupRecovery.pdf+Rebuildm&hl=en&ct=clnk&cd=5 and you can download the pdf at http://searchwinit.techtarget.com/searchwin2000/downloads/pdfs/sqlServerBackupRecovery.pdf

It's a good reference.

Regards,

Ahmed