RE: Granting permission on SP
I tried using this login but not able to alter it as it says permission denied. It is able to create new proc.
2003-06-10
1 reads
Growth
RE: New SQL Server is slower than the old
Decent Q&A is given at the following link (may be information here as well) http://www.sql-server-performance.com/q&a38.asp You may also want to have the Server Engineer check the stripe size and make sure that it is set to 64K. Not usually the default. David
2003-06-05
RE: Logins
It would need to be designed into the frontend. It may be easier (and quicker) for the dba to change all the passwords. The usernames could easily be extracted from the database, and a one off change password script written.
2003-06-04
1 reads
RE: SQL SERVER STALLED
Are you sure the Server is 'busy', or do you have a number of locks on the data? In the first case, I'm afraid you cannot do a lot, besides from optimising your queries. In the last case, you should check the locking mechanism that is used in VB for the connection.
2003-06-04
2 reads
Blogs
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
The Future of the Social Web Is in Good Hands
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers