Viewing 15 posts - 1,906 through 1,920 (of 2,486 total)
Have a read through "Transaction Log Architecture" in Books Online. You should find the answer to your question there.
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface...
November 30, 2003 at 4:08 pm
Is it possible to get the "Logout | Register | Active Threads ..." menu left-aligned on the page?
When there is a post that doesn't wrap the menu gets pushed way...
November 30, 2003 at 3:37 pm
I agree CONVERT does have the advantage of being able to change the output format. It's also handy to bear in mind that you can use CONVERT's type parameter for...
November 27, 2003 at 6:54 pm
Firstly, what are you using to view the text file output? To see the results correctly you'll need to use something that understands the control codes like MS Word.
Also,...
November 27, 2003 at 5:34 pm
I'd actually like to second that suggestion about attaching a file.
Especially for things like DTS problems. It can get a little confusing explaining the workflow of a package. In this...
November 27, 2003 at 4:43 pm
quote:
Quick brainteaser for our beginning DBA's: what's the quickest method to strip out the time from a DATETIME field (returning only...
November 27, 2003 at 4:38 pm
Do you need the blank row for the formatting? Can't you apply the formatting to the title row?
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
November 27, 2003 at 3:35 pm
We would be glad to provide you all the help you need.
How about posting the actual query you're running and the table structure.
Hope this helps
Phill Carter
--------------------
Colt 45 - the original...
November 27, 2003 at 3:32 pm
Well having the staging table on SQL Server will give you a "more elegant" solution than using Access.
For reference, importing data into staging tables, then performing data transformations whilst...
November 26, 2003 at 10:45 pm
Why are you using Access as the intermediate step? Can't you create a staging table in the SQL Server database?
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click...
November 26, 2003 at 10:37 pm
You have a few options,
1) define a seperate transformation for that column. DTS has a builtin datetime transformation task.
2) perform an ActiveXScript transformation for that column. This would be necessary...
November 26, 2003 at 4:41 pm
If you're copying and pasting into Excel, output to text and change the results to tab-delimited.
Then you can copy and paste the whole lot straight into Excel.
Hope this helps
Phill Carter
--------------------
Colt...
November 26, 2003 at 4:32 pm
AER, have a look at the script I've posted here,
http://www.sqlservercentral.com/scripts/contributions/569.asp
It does a find and replace within ActiveXScripts. Probably be able to modify it a bit to search other properties or...
November 26, 2003 at 3:12 pm
With automatic growth of log files, I find that DBCC SQLPERF doesn't quite fit my needs.
The following script identifies any log files that have grown bigger than their corresponding data...
November 25, 2003 at 5:01 pm
AER, you make no mention of what you've attempted, or thought of, in your original post. Unfortunately there isn't any mind-reading add-on for this forum so sometimes the obvious is...
November 25, 2003 at 3:16 pm
Viewing 15 posts - 1,906 through 1,920 (of 2,486 total)