Viewing 15 posts - 4,216 through 4,230 (of 6,401 total)
What error messages from DBCC CHECKDB do you get and do you have backups of the database in question?
I take it with running "REPAIR_ALLOW_DATA_LOSS" that your not to bothered about...
July 23, 2012 at 5:25 am
You cannot change the owner of Master / Model / TempDB or the Distribution databases. The only system database that you can change the owner of is the MSDB...
July 23, 2012 at 5:17 am
Hi
This is primarily a Microsoft SQL Server forum not an Oracle forum.
I dont know about the (ed) command, but your creat table is invalid syntax, it should be CREATE TABLE
July 23, 2012 at 4:25 am
Went to a different Makro this weekend and they had the three main Innis & Gunn's by the case load, so I picked up an original and a blonde, left...
July 23, 2012 at 3:24 am
Run SSCM on both nodes and change the port in the TCP/IP properties of the service.
A quick google shall tell you the steps http://support.microsoft.com/kb/823938
July 23, 2012 at 3:20 am
What do you want to acheive here?
If you have Enterprise Edition you can use a scale out deployment setup and create a host record in DNS for a particular URL...
July 23, 2012 at 2:34 am
What does the job do? Is it firing any triggers which could be sending mail as part of the job step or the remote job step?
July 23, 2012 at 2:24 am
Clicking "hide in tile view" does just that, it only hides them in the tile view, if the users click "details view" they will see everything which they can see.
They...
July 23, 2012 at 1:02 am
Wrap it up inside a sub select like follows
SELECT
SUM(count),
no_of_months_first_redeem
from
(
select count(*) as count, datediff(month,con_date, first_redeem) as no_of_months_first_redeem
from klr_table
where con_date>= '2007-04-01'
group by datediff(month,con_date, first_redeem)
union all
select count(*) as count , datediff(month,convert(datetime, '2007-04-01',...
July 20, 2012 at 7:02 am
Good spot Phil. I shall ammend.
July 20, 2012 at 5:49 am
Number of options depending on what edition of SQL you have depends what you can do.
CDC (Change data capture)
HashBytes on a MD5 hash, if source & target hash dont match...
July 20, 2012 at 5:35 am
Best asking that on a sharepoint forum not a SQL forum I think.
July 20, 2012 at 5:22 am
I'm out too.
Asked for that information a number of times on the different posts, even took the time on one post to actually create the consumable DDL and data so...
July 20, 2012 at 5:20 am
But we need something to work on and without the base data and what the base data should look like after the logic is applied we cannot do the work.
So...
July 20, 2012 at 4:49 am
Viewing 15 posts - 4,216 through 4,230 (of 6,401 total)