Viewing 15 posts - 16 through 30 (of 31 total)
Try looking at sys.dm_db_index_usage_stats
Although a word of warning - although an index may not be used 'frequently', it doesnt mean that it's not valid!!
Do you have the data model of...
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
December 15, 2011 at 2:30 am
Is there an error message? Are there active connections to the db?
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
December 14, 2011 at 8:10 am
Open each of the script tasks individually, and right click - build them... Do they build successfully?
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
December 14, 2011 at 8:05 am
There are various things you can do to monitor what is happening on your database, and give yourself enough information to roll back mistakes.
Try looking into:
Change Data Capture (CDC) http://msdn.microsoft.com/en-us/library/bb522489.aspx
Using...
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
December 9, 2011 at 6:50 am
Restore the backup to a seperate database, identify the rows which were updated incorrectly, and write a query to reverse the action.
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
December 9, 2011 at 6:45 am
To be honest, I'm not sure you'll get the answer you're looking for here (i.e. Do steps x, y and z and you will magically have your original data back).
As...
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
December 9, 2011 at 6:39 am
Do you have a back up of the database?
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
December 9, 2011 at 6:32 am
Which account are you using to run the package? Does it have permissions on both dbs?
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
December 5, 2011 at 6:58 am
I'd probably create a function to do this, and use this to do the conversion.
Create function dbo.udf_StuffString
(@Value float)
Returns Varchar(12)
as
Begin
Declare @Multiple int,
@Output varchar(12)
Set@Multiple = casewhenCHARINDEX('.',reverse(cast(@Value as varchar(12)))) > 0
thenPOWER(10, ...
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
December 2, 2011 at 7:24 am
And to handle the variable number of decimal places, you could try:
select POWER(10, cast(CHARINDEX('.',reverse(cast(@Amount as varchar(10))))-1 as int))
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
December 2, 2011 at 6:58 am
Try somethign like this:
declare @Amount as varchar(10)
select @Amount = cast(cast(20.55 * 100 as int) as varchar(10))
SELECT STUFF(@Amount, 1, 0, REPLICATE('0', 12 - LEN(@Amount)))
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
December 2, 2011 at 6:45 am
Could you provide some sample data?
It sounds like you're either returning duplicate records, or your logic doesn't provide mutually exclusive sets.
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
November 21, 2011 at 8:47 am
The single quotes are only closing the SQL string - they're not identifying the string you're passing to it as a string.
WHERE '+@FieldName + ' = ' +...
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
September 22, 2011 at 4:51 am
I'd take a look at SSIS (MS Sql Server Intergration Services). With a script task for the zip/unzip of files, you should be able to easily automate your requirement.
Try http://msdn.microsoft.com/en-us/library/ms169917.aspx...
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
September 21, 2011 at 1:07 am
What data types are you planning on inserting into the table? If you know that, you should be able to answer your own question 🙂
If you're allowing users to input...
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
September 20, 2011 at 9:10 am
Viewing 15 posts - 16 through 30 (of 31 total)