Viewing 15 posts - 5,716 through 5,730 (of 9,244 total)
tt-615680 (4/12/2012)
This is part of the stored procedure:
........................
...................
CREATE TABLE Data
(
Total_TY decimal(10,2), --this is where is gives the error
Total_LY decimal(10,2),
variance decimal(10,2)
)
INSERT INTO #Data
SELECT
CASE WHEN ISNULL(ISNULL(Total_TY,0)/ISNULL(Total_LY,1), 0)...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2012 at 10:23 am
Greg.Jackson (4/12/2012)
I have an Enterprise Class database (SQL Server 2008 R2) that I perform Index Maintenance on nightly (non peak hours using...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 12, 2012 at 10:12 am
Glad you're sorted
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2012 at 1:19 pm
can you post the table definition and the exact command you used to move the table?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2012 at 10:48 am
jitendra.padhiyar (4/11/2012)
I setup mirroring and can see "Principal, Synchronized" status of Primary...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2012 at 10:43 am
sqlfriends (4/11/2012)
Thank you, I don't see change DNS name in the steps.
When you rename the Windows computer it should change this for you and update the account in AD.
An...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2012 at 9:43 am
beejug1983 (4/11/2012)
SELECT * FROM fn_my_permissions('sp_start_job', 'domain\ABC')
Even if I log on with other user who has...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2012 at 8:15 am
sure, you just need to enable the database option
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2012 at 6:27 am
anthony.green (4/11/2012)
I was thinking of isolation levels at the connection level not at the database level.
You have to enable them at the database level to use them in the query.
For...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2012 at 6:16 am
forsqlserver (4/11/2012)
Hi,Thanks,
I am using XP_CMDSHELL.
On running: Exec XP_CMDSHELL 'c:\te.bat';
It continuosly goes to executing query state.
So, am i correct in saying you can execute this from SSMS query window but...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2012 at 5:10 am
asranantha (4/10/2012)
if u know answers plz tell me
All pirates should find their own treasure 😀
or just maybe research a little more 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2012 at 5:00 am
can you supply a little more info on exactly what you're doing and any errors you receive
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2012 at 4:58 am
There are a couple of options READ_COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_ISOLATION. Both acquire no page or row locks when reading, check BOL for more info on these.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2012 at 4:56 am
the second script bombs as there is a table missing.
Have you considered implementing a more suitable isolation level?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2012 at 4:21 am
seesachinjadhav
build yourself a couple of virtual machines and get yourself going from there. See my guide starting at the following link[/url] for more help.
If you wish you may...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2012 at 3:35 am
Viewing 15 posts - 5,716 through 5,730 (of 9,244 total)