Viewing 15 posts - 7,276 through 7,290 (of 9,715 total)
liewsb (10/7/2010)
Hi Gail and Brandie,Thanks for your helps so far.
AS I just take other this DB job, I really need you all helps to slove this urgent issue now...
Stop. Take...
October 7, 2010 at 11:45 am
But if you're going to rename and alter, you might as well just drop and create. It's cleaner.
October 7, 2010 at 9:40 am
Nakul Vachhrajani (10/6/2010)
Use sys.sql_modules instead.
Thanks, Nakul. I didn't even know this table existed.
October 7, 2010 at 6:08 am
Dropping and recreating procs is a regular part of our SDLC. We only ever use rename when we're going to archive off the proc. We want to make sure that...
October 7, 2010 at 6:07 am
Here's a sample path for where your SSAS database could be located. Check this and see if you can find the .cub and .dim files associated with the cube. Is...
October 7, 2010 at 6:00 am
Chris Morris-439714 (10/7/2010)
INNER JOIN SOP30300
ON SOP30200.SOPNUMBE = SOP30300.SOPNUMBE AND RM20101.DOCNUMBR = SOP30300.SOPNUMBE
Are you absolutely sure that RM20101.DOCNUMBR should match to SOP30300.SOPNUMBE ? Look at...
October 7, 2010 at 5:44 am
liewsb (10/7/2010)
my scheduled backup is from Right click on DB->Task->Backup, and choose Database. The output file is having extension .bak
But you don't say what type of backup you're doing. There...
October 7, 2010 at 5:38 am
GilaMonster (10/7/2010)
This has got to take some form of prize. http://www.sqlservercentral.com/Forums/FindPost1000227.aspxTime to get the crystal ball out again.
Apparently it's my turn to feel snippy. I couldn't resist.
October 7, 2010 at 5:31 am
Google your error. See what you come up with. When you get confused, refer to these threads:
October 7, 2010 at 5:31 am
Brandie Tarvin (10/6/2010)
mbricker-600840 (10/6/2010)
Tom.Thomson (10/6/2010)
Brandie Tarvin (10/6/2010)
CirquedeSQLeil (10/6/2010)
Wow, SSC is all about milestones this week.This thread is about to break 3000 posts too.
Post for the sake of bumping the post...
October 6, 2010 at 12:29 pm
mbricker-600840 (10/6/2010)
Tom.Thomson (10/6/2010)
Brandie Tarvin (10/6/2010)
CirquedeSQLeil (10/6/2010)
Wow, SSC is all about milestones this week.This thread is about to break 3000 posts too.
Post for the sake of bumping the post #. @=)
And...
October 6, 2010 at 12:28 pm
Lately I have found that more posters actually have a problem with their expected result sets because they forgot (or didn't know) what they should be expecting. That it's not...
October 6, 2010 at 12:27 pm
kbnyny (10/6/2010)
October 6, 2010 at 12:26 pm
Stefan Krzywicki (10/6/2010)
October 6, 2010 at 11:53 am
Stefan Krzywicki (10/6/2010)
Brandie Tarvin (10/6/2010)
Stefan Krzywicki (10/6/2010)
Wow, loading data into Access from SQL Server through SSIS is a Royal PITA.
Really? I haven't had any problems with it. What's your issue?
EDIT:...
October 6, 2010 at 11:29 am
Viewing 15 posts - 7,276 through 7,290 (of 9,715 total)