I was talking about the white spaces inside the flat file output.txt. print or select, no difference. The width is a variable, for row1, it could be...
when I use osql to dump some query result into a flat file, the output<br />always occupies whatever length I declared in the query. For example,<br...
I meant, (Backup and Shrink) logfile. -mingus
Or, if you have no money to spend, like me,<br />create a userLog table, and log every critical<br />db execution from your program [<img...
(1) schedule backup and shrink log file; (2) do you really need FULL Recovery, or Simple, or Bulk-Logged? -mingus
Thanks a lot Satya. (1) But I couldn't backup master log file. I scheduled a job for master log backup only, it always fails, the log in EventLog...
I am able to do it without restoring master if the source is Win2k Pro/SQL Server 2K sp3 and the destination is Win2k Svr/SQL Server 2K sp3 But...
This is very strange. I am planning to upgrade my application system from Win2000 server/SQL Sever 2k SP3 to Win2003 server/SQL Server 2k SP3. After...
XP_CMDSHELL works inside sql script, but for a batch file, there is no need to invoke XP_CMDSHELL or using '!!', go straight to the win command....
(1) the query inside input.qry doesn't delete anything, it updates a table - apparently it works file; (2) "del input.qry" is the one to delete the...
I was trying to delete a file inside an osql batch file but it failed, even though the query was executed successfully: osql /U myUser /P myPassword...
when I do a select out of sysindexes, I get some indexes I <br />have never defined, they all named something like:<br /><br />_WA_Sys_<<img...
Thanks Tom. -Mingus
I have indexes cannot be defraged. After I ran this command, I still get scandesity = 33, 50. Maybe because these have only one page each?
Can I schedule a regular job to compile all of user-defined stored procs/trigs and UDFs? Is it true when I run this command against a proc, this...
I found a not so pretty solution by using: select a.name from dbo.sysobjects a join dbo.syscolumns b on (a.xtype = 'D' and b.name = <Column_name>...
Thanks, but I think I need a function to return the exact name of old DF_ since there is no sure way to identify it - someone else could name it...
How to change the default on a column from, for<br />example, '0', to 'NA'?<br /><br />dbo.sysobjects (where XTYPE = 'D') <br />tells you there is a...
I'd like to provide a scripting tool for the customers, instead of asking them to learn SQL Server. The issue is, there is an existing default on...
Separate names with a comma.
