Viewing 15 posts - 661 through 675 (of 872 total)
Matt Miller (3/12/2008)
March 12, 2008 at 11:02 am
Until we can get a definitive answer, I'm taking a break from these procs. I have attached the 2000 and 2005 versions, and as of now they match the output...
March 12, 2008 at 9:24 am
GSquared (3/12/2008)
rajendran.e (3/11/2008)
Please give me idea about basic knowledge for DBA
Get a good book on the subject at your local bookstore, Amazon, the library, whatever.
THE basic datum about being a...
March 12, 2008 at 8:55 am
Jeff Moden (3/12/2008)
Great link for a "System DBA", Adam. What about an "Application DBA" or a "Hybrid"?
This book has probably given the best break down of different type's of...
March 12, 2008 at 8:42 am
http://msdn2.microsoft.com/en-us/library/ms189792.aspx
total_pages
Total number of pages allocated or reserved by this allocation unit.
data_pages
Number of used pages that have:
In-row data
LOB data
Row-overflow data
Value returned excludes internal index pages and...
March 12, 2008 at 8:32 am
SQL ORACLE (3/12/2008)
Did you try the stored proceduresp_spaceused
?
Yes, all M$ system procs (as stated earlier) do not return the results I am looking for.
March 12, 2008 at 8:19 am
March 12, 2008 at 6:04 am
Andrew Watson (3/12/2008)
Try here : http://technet.microsoft.com/en-us/library/ms178085.aspx(Good luck - it's a bit of a monster calculation, although the one for non-clustered is even worse).
Nice find. Wonder if anyone has this figured...
March 12, 2008 at 6:02 am
Mike Levan (3/11/2008)
Msg 15291, Level 16, State 1, Procedure sp_change_users_login, Line 131
Terminating this procedure. The Login name 'AMEMpusr' is absent or invalid.
Msg...
March 11, 2008 at 1:33 pm
Mike Levan (3/11/2008)
http://support.microsoft.com/kb/246133/
looks like everything got trasnfered but when I try to login with some id, its not getting in, is there a chance that...
March 11, 2008 at 1:23 pm
That is an intense error that I can't see I've seen before ... a couple pieces of the error look to be like you may have a consistency or data...
March 11, 2008 at 12:36 pm
Betty Sun (3/11/2008)
Hi Adam,I got it. In Data Transformation Services-->local package->right click on it-->schedule package. then that's it.
Betty
Ok cool, but as stated in an earlier post, this encrypts the DTS...
March 11, 2008 at 12:27 pm
Yeah that's kind of a weird one ...
Without spending to much time on this, this will at least give you the objects that do not have explicitly granted individual...
March 11, 2008 at 12:05 pm
Betty Sun (3/11/2008)
I am trying to schedule a job.
enterprise manager-->management-->jobs-->new job.
on the general tab, on the drop down menu "category", I was able to pick up a DTS package...
March 11, 2008 at 11:53 am
Viewing 15 posts - 661 through 675 (of 872 total)