blahknow (10/22/2007)

---

Excellent indeed !!!

That solved the problem !!!:D

Thank you v e r y much Andras !

Is there a book that can be helpful in incidents such as this ?

Thanks again...

blahknow (10/22/2007)

---

Hi,

yields

fiftyplus_Log ...

Could you also check if filegrowth is set:

select name, size, maxsize, growth from sys.sysfiles where fileid=2

Andras

connect_ninad (10/22/2007)

---

I think u need to shrink the log file after taking backup...

Step 1 :

u can use the following command :

backup log with truncate_only

Step 2 :

Go...

blahknow (10/22/2007)

---

Hi Mr or Mrs. 500

I used your advise, ran the query and got the following message:

Processed 66 pages for database 'fiftyplus', file 'fiftyplus_Log' on file 2.

BACKUP LOG successfully processed...

You can use a statement like:

BACKUP LOG foo2 TO DISK = 'G:\foo2.bak'

where foo2 is the name of your datebase.

You can read more about the backup at http://msdn2.microsoft.com/en-us/library/ms186865.aspx

Make sure you have...

You could export the data using bcp, then import it? But there are excellent third party tools that can help you here. They can map columns in such data movements....

Hi Sandy,

in addition to my previous post, you can get more information about the computed columns from the sys.computed_columns view. This also contains the computed expression you have specified....

Hi Sandy,

you can get the above information form the system views. Schema objects are in sys.objects, columns are in sys.columns, data types are in sys.types (I assume you are on...

You could either use a user defined function or a procedure with an output parameter.

Two examples:

CREATE FUNCTION dbo.f1 ( )

RETURNS INT

AS BEGIN

DECLARE @a INT

...

Writing binary data, especially if you want to write out to several files, several objects, ... to disk is a bit of a pain. Your best bet would be to...

Conway Painting is of course right, that you would generally return the data in the result sets. The temptable and table variables in this case are most useful for producing...

Hi,

you could use both table variables and temporary tables. In terms of scope both of them will be restricted to your stored procedures. Both have advantages and disadvantages. Basically if...

On possible breaking behavioral difference in SQL Server 2005 that concerns datetime functions is that converting character strings to datetime implicitly is now considered to be non-deterministic. This is more...

EXECUTE sp_updatestats...