Just a short note about the alternative to this, it may be worth to get used to switching to simple recovery mode and then back to full. The BACKUP log...

Hi Andy,

You could use a function like:

CREATE FUNCTION f ( @a VARCHAR(2000) )
RETURNS xml
AS BEGIN
    DECLARE @res1 varchar(2000)
    SET @res1 = ''
  ...

You can paste the link to Microsoft document explorer (BOL)

Alternatively the same is available on:

http://technet.microsoft.com/en-us/library/ms190243.aspx

Regards,

Andras

XML PATH has been introduced in 2005 only. XML RAW was part of 2000 too. XML PATH is much more flexible

Regards,

...

You can add extended properties to the whole database, i.e. not to schema, objects, or columns. These have the level0type (as well as level1type and level2type) set to null.

You can...

If you are referring to a database object called VIEWCHECKOPT in a view, function, trigger, ... that does not exist anymore (you can have this easily), you can identify the...

Hi AT,

you are right that initially the tempdb is in the SQL Server installation folder, but it is easily changed with two "alter database tempdb modify file" statements. The master...

I do not think you will get performance improvements by installing SQL Server to a different location than the standard location. However, what does matter, is where you put your...

Hi Kyle,

The fastest solution is to:

1. take the definition of this sp (methods we have already shown you, easiest is to use Management Studio, find this stored procedure in the...

This post is a duplicate of http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=398832

Regards,

Andras

You may want to call you stored procedure sp_something. If it starts with 'sp_' and is in the master database, it will be available in all of your databases.

For executing...

Indeed the dbname is missing. I've forgotten to escape the < Many thanks

Andras

Hi Matt,

I'm not absolutely convinced by "WITH TRUNCATE". "TRUNCATE_ONLY" seems to work however, it is the same as "NO_LOG".

Andras

From T-SQL you will not be able to get both of the result sets.

As Markus mentioned, you could take the definition of sp_helplogins

select definition from sys.all_sql_modules where object_id =...

BACKUP log WITH TRUNCATE_ONLY

dbcc shrinkfile('myDatabaseLogName')

you need to fill in the database name and the logname

I strongly suggest you read http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=352434#bm352437 and make a full backup.

Regards,

Andras