After adding your account to the group you just have to log off and then log on in the client.

Also, make sure you have the same Service Pack on both...

With DBCC SqlPerf(LogSpace) you can get the percentage free and the total log size.

Use the following script to get free and used log space.

create table #logspace

( dbname varchar(50),

...

That group was created locally in your machine when you installed AS.

Go to: Control Panel -> Administrative Tools -> Computer Management -> Local Users and Groups -> Groups

Add your...

Also you can query the sysprocesses system table to see the current processes:

 

select * from master..sysprocesses

SQL uses a proxy account when you run a job or xp_cmdshell with a user who aren't a sysadmin. This proxy account doesn't have to be a part of the...

 

Select * 

From TableName A

Where year = (Select MAX(year) From TableName B Where B.ID = A.ID) 

Try this:

 

RIGHT('0' + CONVERT(VARCHAR, DAY(GETDATE())),2) 

Edited by - mdaniel on 12/08/2003 12:42:36 PM

quote:

---

From BOL:

A value of NULL indicates the value is unknown. A value of NULL is different from an empty or zero value....

The NULL value cannot be ignored because it's a record with a value NULL.

SQL checks all (4) records in Table2.

The value NULL means the data value for the column is unknown. In your query, SQL compares each value in the Table1 with the subset returned from the Table2. Since...

The distinct count aggregation function can be used only on numeric data type fields.

Which error do you get? Are you using the Copy Database Wizard or the Copy SQL Server Objects Task?

In fact, it's recommended to migrate the repository to SQL.

Have you checked the format of the repository? ie. Metadata Services or Native Format?

You can use only one fact table, but you can create a view to join all the fact tables and use the view as a fact table in AS.

To check which SP in AS is installed, go to Analisis Manager, right-click on Analysis Servises, then click on About Analysis Services. If the version is 8.0.760 or greater, the...