Viewing 15 posts - 841 through 855 (of 2,897 total)
Got it.
p.s. I don't know what most of your certifications mean, but I would think you've earned ROFL and LMAO by now.
August 16, 2011 at 12:54 pm
Thanks
What I'm testing is an insert inside a stored procedure, that joins to a table on another server (linked server) if that makes any difference.
Don't try clearing any cache or...
August 16, 2011 at 12:30 pm
Welsh Corgi (8/12/2011)
Good thing you had a backup. 🙂Just wondering but why did you decide to perform a SELECT INTO and subsequently TRUNCATE the table?
Yes, there are many questions that...
August 12, 2011 at 2:43 pm
Here's a thread from the other day with some of what you're looking for. Have you searched around much ?
http://www.sqlservercentral.com/Forums/Topic1156166-146-1.aspx
August 12, 2011 at 2:37 pm
rajeshn29.dba (8/12/2011)
i want to take two tables backups ...............can you plz some tell me procedure
I don't understand your question.
You already know how to backup a table as you did...
August 12, 2011 at 2:09 pm
If you have identity columns that you want to maintain, then you may need to add something like
SET IDENTITY_INSERT BKP ON
insert into EMP (Fld1, Fld2, Fld3)
select * from EMP_BKP
SET...
August 12, 2011 at 1:58 pm
Welsh Corgi (8/12/2011)
Perhaps I misunderstood but I did not interpret that inserting the records from EMP_BKP into EMP is the desired solution.
Just as likely that I misunderstood.
I thought that:
1) EMP...
August 12, 2011 at 1:39 pm
insert into EMP
select * from EMP_BKP
August 12, 2011 at 1:15 pm
Leo.Miller (8/10/2011)
August 10, 2011 at 2:49 pm
Ninja's_RGR'us (8/10/2011)
I ran your code George but I was missing all the application roles. So I can't use it atm!
Will it work if you change this:
[font="Courier New"]select 'exec sp_addrole...
August 10, 2011 at 12:22 pm
The "best" solution depends on how complicated the transaction is. If it's just writing records to a table, then his idea of deleting might be good enough. Or make a...
August 10, 2011 at 10:00 am
What are your specific problems, errors, settings etc ?? ....
Being specific will get you better answers (not that I am likely to have any).
Also, I think it...
August 8, 2011 at 10:07 am
Are you still on SP2 ?? I hope not.
August 8, 2011 at 9:15 am
Idera also has object level restore. I don't think any of the 3rd party backup tools are very expensive.
August 3, 2011 at 3:02 pm
I have a need to pre-populate a list of the 5th business day each month. Any idea how to do that ? :hehe:
August 2, 2011 at 8:07 am
Viewing 15 posts - 841 through 855 (of 2,897 total)