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
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...
(Backup and Shrink) logfile.
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?
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
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.
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
(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
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...
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,
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
The issue is, there is an existing default
Separate names with a comma.