Forum Replies Created
Viewing 15 posts - 181 through 195 (of 327 total)
-
RE: Failed jobs with SP2
I don't know if this is the cause but SP2 prior to March 7 requires a patch due to issues in the Maintenance Plans. I think the patch was rolled into...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Current Activity Window not coming up
One more thing, EM uses tempdb for this so if tempdb is extremely busy, timeouts will occur.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Running an executable from within a stored procedure
The Ole Automation SPs are actually XPs (DLLs) and require that the user be in the sysadmin role. I don't think that granting execute privileges on them will alter that....
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Browse DBs and tables of linked server
I just found this on the MSDN forums:
"The functionality to view remote tables/views for linked servers is not available in SQL2005 Management Studio. You can use the system stored...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Browse DBs and tables of linked server
Yet another useful feature that Microsoft removed. I haven't found a way around this either.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: That @*!! Information_Schema
I just found sys.all_views which is probably better for your purposes rather than sys.all_objects
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: That @*!! Information_Schema
I haven't tried this, but the 'sys' and 'INFORMATION_SCHEMA' schema_id numbers are 3 and 4 respectively, so you might try somthing like this, paste the output into another query and run...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: SQL 2005 Standard Edition Memory Management
OOPs -that should have been SQL2K5 Standard Edition
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: SQL 2005 Standard Edition Memory Management
SQL2K5 can address whatever the operating system maximum is. If you have more than 4GB of memory it's a good idea to use 2GB...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Uninstall just BOL
sorry - Access Control List. Yes, it is permission talk.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Uninstall just BOL
If you don't want to delete the folder (I imagine that would be for a "just in case"), change the ACL to allow only your login to access it and...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: Granting select to tables via Management Studio
I don't know if SP2 will make grants easier but Maintenance Plans have been added to SSMS that will have a similar look and functionality to EM
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: The 400,000 Member Milestone
Hit the button too soon. I wanted to add that there are lot of people that feel the same wa and that is what makes this such a successful site!
Once...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: The 400,000 Member Milestone
I'd like to add my congratulations and my thanks (plus one more post
)Without a doubt, I get the most help for SQL...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
-
RE: The BI Year
"technology is maturing"
You have no idea! Everyone seems to have forgotten (or didn't know) that there is language out there that has been using multidimensional arrays for over 20 years...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
Viewing 15 posts - 181 through 195 (of 327 total)