Viewing 15 posts - 6,481 through 6,495 (of 18,926 total)
So this is a 1 time import you want to do?
Just run the code manually in excel after you've changed the connection string. It should work straight away or...
May 4, 2011 at 5:42 am
sachnam (5/3/2011)
Ninja's_RGR'us (5/3/2011)
You'll get the same error if the server is restarted or if someone killed your SPID.
hello Ninja,
I always respect your words but the Error msg we recieve...
May 4, 2011 at 5:41 am
navneetpatel (5/4/2011)
Replace...
May 4, 2011 at 5:20 am
latitiacasta (5/3/2011)
my requirement is bit different but your query gave me idea how to reach that
once again thank you so much for your...
May 3, 2011 at 9:26 pm
Assuming you have a unique key on emp_id, dep_id
SELECT emp_id, COUNT(*) AS CntDep from emp_dept GROUP BY emp_id HAVING COUNT(*) = (SELECT COUNT(*) FROM dbo.Departements)
May 3, 2011 at 9:25 pm
Timestamp is a rowversion. This is kept 100% by the server. You can select it but you can't insert / update it.
Just leave that column out of the...
May 3, 2011 at 9:22 pm
daveriya (5/3/2011)
hiON DELETE CASCADE is applied while table creating ,here table is already created
i cant change them
Can't or not allowed? Cause I'm pretty sure you can change that...
May 3, 2011 at 9:17 pm
Should be done client side when presenting the data.
If this is for some e-mail warning or report then do as CC already suggested.
May 3, 2011 at 9:17 pm
Given to 8 consultants with RDP access from outside the network.
Then when I changed the pass after your possible attack warning last week I got an earfull from the network...
May 3, 2011 at 9:16 pm
You can always move to simple recovery, then delete in small batches so the log doesn't grow on you within the transaction.
But AFAIK you haven't tested all of Perry's options.
May 3, 2011 at 8:51 pm
Jeff Moden (5/3/2011)
May 3, 2011 at 8:08 pm
What are you using as front end? If you are still using access then nothing's changed (well almost). You'd just need to update the connection string in the...
May 3, 2011 at 7:33 pm
Jeff Moden (5/3/2011)
Ninja's_RGR'us (5/3/2011)
Jeff Moden (5/3/2011)
SwePeso (5/3/2011)
See this topic. We hammered the subjet to death...
BWAAA-HAAAA!!! With only 55 rows of test data on one hand and only 8788 from...
May 3, 2011 at 7:30 pm
Jeff Moden (5/3/2011)
SwePeso (5/3/2011)
See this topic. We hammered the subjet to death...
BWAAA-HAAAA!!! With only 55 rows of test data on one hand and only 8788 from the "Adventureworks" hand,...
May 3, 2011 at 7:01 pm
The subreport is a report. It can still be "saved" in the database (which btw is what happens in the reportserver DB).
My only personal preference is to store those...
May 3, 2011 at 6:49 pm
Viewing 15 posts - 6,481 through 6,495 (of 18,926 total)