Devvy, look at David's answer, understand it and implement the idea, he has identified problem and told you the solution. Managing really large transactions can be a complete PITA.
Never underestimate the power of human stupidity RAH
hi.. everybody i got the solution here.. http://community.discountasp.net/showthread.php?t=4402 but now again i'm in a problem how to assign security role for different system in a network for a folder or it can be report.. i want to assign diferent permission for different users..
Mycroft Holmes wrote:
How did you get that from the OP.
He's cheating, the mindreader function is to be released with SQL:2012.
"When did ignorance become a point of view" - Dilbert
henry1951 wrote:
I chose them for the absolute certainty that there would be no collisions in IDs
Actually it's not an absolute certainty. It's just that the chance of a collision is extremely small. Be careful using GUIDs as PKs. Significant performance issues can arise (both time and space are wasted) when the clustering index is a GUID and the default in SQLServer is to create a clustering index on the PK. You can get around this by using the newsequentialid()function or by generating your own sequential GUIDs. See this article[^]for a discussion of the issue.
Alireza Loghmani wrote:
Save them in db or save them on disk?
Isn't the DB on disk? :confused: I'd just stick it in the database; easier to backup, copy, etc. Plus, I'd live in fear of someone deleting or modifying the files.
jrahma wrote:
I want to know how can I list all database in mysql?
By keeping track if the tables you make. Create a tabled called "MyTables", and add an entry whenever you successfully issue a CREATE command :)
I are Troll :suss:
I'm assuming that the IIS is hosted on the same server as the SQL db? If so, it's making a local connection whereas clients are connecting over the network - based on this make sure that: 1) you have SQL configured to allow the type of connection you are trying to use from the client (IP, pipes, etc.) 2) you have the firewall configured to allow SQL traffic (I've had this problem in the past where the MS firewall didn't automatically add a rule for SQL) Those are my initial thoughts.
What does it say in the event log?
I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be
Forgive your enemies - it messes with their heads
My blog | My articles | MoXAML PowerToys | Onyx
Use Print(sql) to have a full customized query.
Regards, Hiren. "We owe a lot to the Indians, who taught us how to count, without which no worthwhile scientific discovery could have been made." - Einstein Microsoft Dynamics CRM
Use
DBCC CHECKIDENT('Customer', RESEED, 0)
for Resetting Identity seed.
Regards, Hiren. "We owe a lot to the Indians, who taught us how to count, without which no worthwhile scientific discovery could have been made." - Einstein Microsoft Dynamics CRM
