Viewing 15 posts - 3,286 through 3,300 (of 9,725 total)
IF OBJECT_ID('tempdb.[dbo].[#sample]') IS NOT NULL
DROP TABLE [dbo].[#sample];
create table #sample(sno int identity,ChildID varchar(30), ParentID varchar(30),task varchar(50));
--Corrected code by removing extra paren preventing table creation.
insert into #sample (ChildID,ParentID,task) values('222','111','aerospace');
insert into #sample...
April 16, 2014 at 6:50 am
rollercoaster43 (4/7/2014)
Sorry to Jump in here but I was facing the same issue and thought of continuing on the thread.
I have a Stored procedure created in MAster DB which...
April 16, 2014 at 6:39 am
Did you check Jeff's other recommendations? The owner / creator of the proc being SA or someone with sysadmin perms? The database being owned by SA or an account with...
April 16, 2014 at 6:35 am
How are you "pointing" SQL Server? Is this an attempt to connect via SSMS or an actual connection string in a program?
When you say "but in place wher i point...
April 16, 2014 at 6:31 am
Agreeing with Cody here.
I learned the hard way in my first job that trying to "fix" the data for purely cosmetic reasons can and does screw with the end users....
April 16, 2014 at 6:18 am
Brandie Tarvin (4/10/2014)
Yes. Please post this to the appropriate forum for your SQL version under Business Intelligence or General. This is not the proper forum for this quesiton.
April 10, 2014 at 8:24 am
Yes. Please post this to the appropriate forum for your SQL version under Business Intelligence or General. This is not the proper forum for this quesiton.
April 10, 2014 at 8:19 am
Chris Wooding (4/1/2014)
April 1, 2014 at 4:26 am
Odd question. Is there perhaps a database trigger that is rolling back any attempts at A) Executing this proc, or B) deleting data from this (or all) tables?
March 31, 2014 at 11:50 am
I think Lowell's on the right track here. It seems the jumping around has a lot to do with your issues.
If you are able to impersonate the login using this...
March 31, 2014 at 8:33 am
Is there any other information in the error you're seeing?
I've run into this issue when the procedure is doing activity that requires higher level permissions (such as Truncate Table), but...
March 31, 2014 at 6:05 am
I started off using 1024, but the math still doesn't work out correctly for what I'm seeing. (FYI: I got the 128 from a couple of different blog posts. Here's...
February 11, 2014 at 7:44 am
Steve Jones - SSC Editor (1/22/2014)
Did you check properties on all subfolders or use some other method?
The subfolder properties don't tell me if compression is on for them. I experimented...
January 22, 2014 at 9:17 am
Ah. I think it didn't uncompress the subfolders. The root allows me to restore the database files there just fine.
So, nevermind. Thanks for reading.
January 22, 2014 at 8:00 am
Viewing 15 posts - 3,286 through 3,300 (of 9,725 total)