Viewing 13 posts - 1,066 through 1,079 (of 1,079 total)
Hi Elliot
I use them in dts, but I did specify them as variabes outside the script in the dts configuration.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 15, 2009 at 12:55 am
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...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 7, 2009 at 11:54 pm
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...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 7, 2009 at 11:51 pm
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...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 7, 2009 at 7:29 am
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...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 7, 2009 at 3:14 am
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...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 4, 2009 at 5:13 am
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...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 4, 2009 at 4:59 am
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...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 2, 2009 at 11:13 pm
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...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
August 31, 2009 at 4:07 am
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...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
August 31, 2009 at 1:42 am
Hi...
Try some of these, some area bit elementary though....
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 Spatial Data)
Have Fun...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
August 31, 2009 at 1:28 am
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...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
August 28, 2009 at 4:15 am
Hi Nitin
Provide us with your current proc..we'll work from there.
Cheers.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
August 27, 2009 at 11:41 pm
Viewing 13 posts - 1,066 through 1,079 (of 1,079 total)