Viewing 15 posts - 7,306 through 7,320 (of 7,466 total)
with EM you'll have to script all and extra check-select script user-permissions and roles. It's not on by default and is to be found on the same tabpage where you...
November 17, 2003 at 2:20 am
<But I thought that the real reason for this thread was that the job got stuck?>
No, that reason is known (user32.dll cannot be initialized ... related to MS KB-article).
After upgrade...
November 6, 2003 at 5:13 am
Sets see : 1 instance with 1 db returns in 1 second.
1 instance wit 190db's takes way longer.
Your 1-190-instance has to manage 190 db's (with at least 2 files) and...
November 6, 2003 at 3:44 am
the delay is 0 because that's what the users want ! I know that can cause problems, but I'm not alowed to alter this to a more reasonable figure.
The reason...
November 5, 2003 at 8:52 am
Now there a litle bell ringing somewhere...
I didn't realize you were using linked tables from access to sqlserver. In that case, access usualy will try to solve the query by...
November 5, 2003 at 6:28 am
Sqlserver is an advanced database engine !
Access is one of the ancestors. If you want to optimize it you can try to apply the same guidelines you would use...
November 5, 2003 at 12:30 am
If your data is numeric, store it in a numeric typed column. This will requier more work if your data-requierment changes, but it's a good practise to type your data...
November 5, 2003 at 12:19 am
Viewing the responses, you 'll notice that you'll have to test your solution !
My default is to put a clustered index on a table and to remove it if it...
November 3, 2003 at 8:27 am
When the package's job goes wrong, what's it saying in the jobs jobhistory ?
November 3, 2003 at 8:17 am
check the job-owner. Don't use a windows account as job-owner, it might fail with authentication-check.
November 3, 2003 at 2:00 am
take good care NOT having a windows-account as jobowner. (make it a SQLuser which has enough permissions to run the dts-packages)
If you are using a windows-account as jobowner, you'll find...
November 3, 2003 at 1:58 am
Yes, Yes, Yes
1. Should not be dependant on Outlook or MAPI components like Microsoft Exchange profile etc. Should be able to use POP3 or SMTP mail services to send mails.
2....
November 3, 2003 at 1:44 am
just to remind you sysdepends is not a full solution. (create a stored proc that calls an sp that does not yet exist. you'll get a notification)
October 30, 2003 at 11:48 pm
- sql profiler for a while
- check its results
- sql profiler to support the next step and gather the errors
- rename 'tobedeleted' views to 'obsolete'
- after a while
- stop sqlprofiler
-...
October 29, 2003 at 5:32 am
The table is still functioning because the row-data-length did not yet reach the maximum limit for a page.
However, sqlserver did raise a warning regarding this issue at creation time of...
October 29, 2003 at 12:23 am
Viewing 15 posts - 7,306 through 7,320 (of 7,466 total)