Steve - why I said "proper education" is because the training acadamies in South Africa are more about making money, than actually training people, and sending them in a good...

I have never been one for opening a book and studying...hands-on is more my style...

But yes, I do think that education is vital. Most employers are amazed when you can...

Hi Elliot

I use them in dts, but I did specify them as variabes outside the script in the dts configuration.

Hi

This is not new to SQL2005.....

Easy way to do a Differential Backup..

1. Right click on you DB in SSMS

2. Focus on "Tasks" then -> "Backup"

3. In the Backup Type select...

Hi, not new....

Using the GUI to do backup, or configure the backup task in SSIS, specify to do 1) Full 2)Differential Backup.....

Short "how-to" - easy way...

1. Right Click your...

I dont think (my own personal opinion) that SQL was designed for this type of input data?

rather stick to the basics and backup the mails or even enable and configure...

Rock, instead of concentrating on not granting access to any users, did you check that maybe youdomain\everyone

or an "all users in domain" group have been granted access?

sounds like there...

The problem at hand is: the DT replication software (and this has been confirmed with the vendor)

has to replicate the whole file. We tried differential replication, but it stars the...

no its basically just mdf and ldf replication.

the app doing the replication couldn't tell the difference between a mdf or a mp3 😛

it's replication is amost real time, but takes...

Hi Steve

Interesting read..

Here in South Africa the economy is also in it's worst state at the moment, in the middle of a "technical recession".

Difficult to say what one would...

Hi, the flat file source you are using, is it a normal text file,or perhaps csv?

Rerun your job and look for a column name that is giving the issue.

I know...

Hi

Try inserting a conversion step in you package. Doesnt sound like you are using float data as the source?

With flat Files, you can also specify the conversion in the...

Hi...

Try some of these, some area bit elementary though....

http://sqlcourse2.com/

http://msdn.microsoft.com/en-us/library/aa213245(SQL.80).aspx (SQL 2000)

http://downloads.techrepublic.com.com/abstract.aspx?docid=264229 (Registration Required)

http://www.microsoft.com/sqlserver/2008/en/us/whats-new.aspx (Have a look at all new features - Especially...

Hi, I believe the following may help with your request..not quite sure exactly wht you need...but try this..

-----------------------------------------------------------------------------------------------------

set nocount on

declare @permission table (

Database_Name sysname,

User_Role_Name sysname,

Account_Type nvarchar(60),

Action_Type nvarchar(128),

Permission nvarchar(60),

ObjectName sysname null,

Object_Type...

Hi Nitin

Provide us with your current proc..we'll work from there.

Cheers.