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...
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...
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...
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...
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 don't know how to title this question. (1) I have a program using ADO, it deletes ONE record in an AdminTable - this should take no time; (2)...
One of my customers has a query runs frequently, something like: where cast(getdate() + @inputtime - timestamp as dec(10,2)) > @thresholdvalue from...
We have a process does db inserts in the range of 50~100 per second, which blocks other from using CPU and IO from program to/from db. The HW is norm...
it seems that SQL doesn't allow CURSOR to be created on an indexed view, even if it is a READ_ONLY, STATIC cursor. Can anyone confirm this? Thanks....
SQL doesn't allow exec a proc inside a UDF. WHat I need is the UDF returns a string, but I also need this UDF to execute a block of updates. Any...
I have MS Outlook 2000 as a mail client. In my SQL Server Agent properties, there is only one selection: MS Exchange Settings available for Mail...
We can use<br /><br />SELECT *<br />FROM OPENDATASOURCE(<br /> 'SQLOLEDB',<br /> 'Data Source=ServerName;User ID=MyUID<img...
Does ADO support transactions cross different databases? say my program calls a stored proc: [database1].[dbo].proc1 by connecting to database...
(1) How do find out the MDAC version we installed? (2) which version of MDAC is associated with msado15.dll? (3) what is the corresponding msado?.dll...
I was trying to restore customer dbs at my lab server. I restored the user db from customer's backup file, and rebuilt master from customer's master...
I don't understand why this table is "user-defined" table (xtype = 'U')? select * from [your_db].[dbo].sysobjects order by name it shows:...
there are host_name(), user_name(), but no pwd() according to System Functions in BOL.
Separate names with a comma.
