RE: Single user mod
Hai Vidas,Ok, can u tell me how can i put, for example the DB 'TEST1' to single user mod ?pls give me the commands pls
2005-04-25
Hai Vidas,Ok, can u tell me how can i put, for example the DB 'TEST1' to single user mod ?pls give me the commands pls
2005-04-25
You're a legend. Server had set up permissions on the security section but not the actual permission for the SQL login.Thanks, it works perfectly now
2004-09-05
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-09-03
Thanks for the kind words Tim, I'm sure one day you'll be helping me out with a problem.The beauty of these forums, is that there is always someone willing to help.Shane Stecher
2004-07-01
I'd bet the on the 64bit issue. If you can't recompile, I'm not sure what you can do. Did you register this on the server adn in SQL?
2004-04-08
I would first think about the actual need to change everything. VARCHAR(n) makes sense when you expect significant differences in the length of the information to store. If that is not the case, the use of CHAR(n) might make sense.
2004-03-12
Are we saying that in these circumstances funtions are OK. It's only against very large tables there is a problem? No. A Function procedure gets optimized the same as any other procedure or query. What matter inoarticular with functions is "How many times is it called?"This is because the performance overhead that you incur with […]
2004-02-25
What do you mean by: It should not be caused by Auto Close That IS the message seen when Auto Close is set to ON for a database. If Auto Close is set for off, check your SQL Server error logs and the Windows Event logs. You might find other indications of problems. Something might […]
2003-08-26
2 reads
SQL Server 2000 provides a secure administrative link between the Distributor and Publisher and I don't think changing the password of the account under which SQL Server runs has any impact on this especially as the two are on the same Server in your case. Cheers.
2003-07-11
1 reads
Hi there The admin comment, this is a classic case of "roles and responsibilities" that have been lost and forgotten. I dont trust any sys admin to do their job, even my best mates that have been working in the industry for years :-). Always backup via sql-backups, and try and duplex the backups to […]
2003-06-22
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers