sindhu_sing (9/24/2007)

---

Hello I am new to sql server 2005....i have downloaded the 180 days trial version.

I don't have the sql server agent in my version...so how can i create jobs...

Hi Lester,

this is correct. If you switch from simple...

Hi Pravin,

As far as I know there is no equivalent to schema_ver in 2005. The only thing that is similar is the modify_date of the sys.objects table I mentioned above.

Regards,

...

You can use UNION ALL to add the result of a query that returns the totals only.

You will probably want to order the whole union all statement if you want...

http://msdn2.microsoft.com/en-us/library/ms190612.aspx

is a good starting point about learning the basics about transactions.

Regards,

Andras

This is expected behavior. let's say your transaction that modifies the data adds temporary information. E.g in case of accounts that a person has 1000000 USD

Hi Lester,

concerning the best way to schedule the backups, it depends on your requirements (whether you can live with loosing one hour/one day worth of data, ho fast do you...

Hi Lester,

1: Does not ignore it. It uses it in case the server goes down, so the database can be recovered if it goes down unexpectedly. But this means that...

http://msdn2.microsoft.com/en-us/library/ms179316.aspx

is a good place to start. As Noel mentioned, Books Online is a good resource to learn about filegroups.

Andras

Hi,

you can restore the full backup only, and ignore the log backup. The disadvantage is that you will not have the data modifications since the full backup. If you...

DDL triggers are indeed nice, but it is rather common to disable all of them before certain changes So while they are really...

Hi Pravin,

have a look at the sys.tables system view. It contains a modify_date column (it is inherited from sys.objects, which has this information for all schema objects).

You can read more...

SELECT

name FROM otherdb.sys.database_principals WHERE TYPE =...

You could use pivots to rotate the talbe, like:

SELECT Vendor,

[State],

[Monday],

[Teusday],

[Wednesday],

[Thursday],

[Friday],

[Saturday],

[Sunday]

FROM ( SELECT Vendor,

[State],

[Weekday],

Amount

FROM

SQL Server is actually right here. While we know that we are processing the first parts of the string, the select @x=@x+ ... is not a very nice thing to use...