For a much more easier way of backing up the databases, you can use SQL Backup, this is a good third party application, which allows you to also encrypt the...

Thanks

Figured it out and used the following syntax:

select Name, pwdcompare(name, password_hash) as Same_As_Login_Name from sys.sql_logins;

🙂

Hello

I got the result i wanted quite alright, but the result appeared with three different grids, in which it will be hard for me to use a report.

Any...

Am getting the same problem, where it says that the backup file can not be accessed as it is been used by another process.....does anyone know how i can find...

I have also tried to use

select sum(total)as Total_of_All_Tables

from table_a

union

select sum(total)as Total_of_All_Tables

from table_b

union

select sum(total)as Total_of_All_Tables

from table_c

union

select sum(total)as Total_of_All_Tables

from table_d

but need to the table names to be displayed

This is what i have done so far, can anyone tell me what am doing wrong?

select sum(total)

from table_a, table_b,table_c,table_d

where table_a.total = table_b.total

and table_c.total = table_d.total

Thanks very much

The distance will be based on the user input from the search option on the front end application

I also get this error message

Msg 111, Level 15, State 1,...

This is what I have done so far, and if you see its the declaration of variables am problems with.

use master

create database test

use test

create table company

(company_id int, company_name varchar...

Hello Jeff

Am a novice when it comes to stored procedures and i really need guidance, in creating this stored procedure that will include functions.

Any assistance is highly appreciated to help...

couldint find Microsoft OLEDB provider for Oracle, nearest to that option was the oracle provider for OLE DB, is that what you mean?

Ran the script on 2K, and got the following error msg:

Server: Msg 170, Level 15, State 1, Line 6

Line 6: Incorrect syntax near '0'.

Server: Msg 103, Level 15, State 1,...

I got the following error msg:

Msg 102, Level 15, State 1, Line 6

Incorrect syntax near '0'.

Msg 103, Level 15, State 4, Line 11

The identifier that starts with 'AdventureWorksSELECTAdventureWorksDBNameAdventureWorksAdventureWorksAdventureWorksAdventureWorksAdventureWorksAdventureWorksAdve' is too...

What do you mean by DECLARE@db_name, and how can i get this thing sorted out?

Ran that script you posted and i got the following error messages:

Msg 170, Level 15, State 1, Line 6

Line 6: Incorrect syntax near '0'.

Msg 103, Level 15, State 7, Line...

Hello am running this script and am getting this error message:

Msg 137, Level 15, State 2, Line 10

Must declare the scalar variable "@db_name".

trying to figure out where am going wrong?

/*

**********************************************************************

*...