You need to log in as the SQL Server service account and map the drive in that context. In which case, if the service account doesn't have permissions, catch-22. You need to either grant access to the service account or change the service account. Mapping a drive does not make security vanish.
@FreshPrinceOfSO I didn't say it sucked. I thought it was funny. Years ago I had a co-worker who did that kind of thing all the time. "Hey, have you ever played with DMVs?" when he was trying to get a row count for a table.
@Gonsalu sure, performance was never the problem. The problem is they're only as reliable as your network. Really bad things can happen if the connection gets severed.
@Gonsalu performance was the problem when people tried to do it over 10Mbit or 100Mbit connections. These days I hope those are rare.
@AaronBertrand I want to make sure I'm asking for the right thing here. If I want to query an MS Access file, would a linked server be the correct solution? When I try to use OPENROWSET or OPENDATASOURCE using a UNC I get The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.
@Gonsalu well it's kind of like cleaning up litter nationwide. The scope of what's wrong and what could be better is so large, how much could even a team of that size fix everything?
Oracle 11gR2 Exadata
I'm required to uniquely identify when records are created in time. Sequence caching means I cannot use a sequence-based ID and batching inserts means that all records inserted in one batch will have the same timestamp value (even using TIMESTAMP(9)). Akin to Twitter's sinc...
@jcolebrand you can nest BEGIN TRANSACTION statements. That increases @@TRANCOUNT but doesn't actually change your ability to commit / roll back individual transactions. COMMIT/ROLLBACK apply to all.
@Gonsalu switch to Oracle? I don't know. No software is perfect, no QA team is perfect. Since CUs are technically only supposed to be applied when you suffer from one of the issues it actually fixes, and are actually documented as being less regression-tested than service packs, I don't think you can place all blame on Microsoft.
@Gonsalu I'm not defending imperfection but how much regression testing did you perform with the CU? Did you find this problem in QA or in production?
@Gonsalu then that's the risk you (or the people who pay you) take. Microsoft doesn't make it a secret that CUs are not well-tested and that you are rolling the dice.
I think Microsoft has released more service packs with major issues than without. This isn't something about "lately" - you just have to weigh the good with the bad. If you don't like imperfection, go find an RDBMS that is perfect. Good luck.
Does anybody else understand exactly what this person needs?
I don't want to add another column to the import export tables because I want to 'reuse' those rows. If I were to do it that way I would have to create a new row in the import export table for every transaction. If I were to create a transaction table how could I define a transaction that may change.(just a new row?) — Archangel331 min ago
What does FirstName+' '+LastName do in the following Select statement, is it really necessary? I tried omitting it, and it produced the same result.
SELECT FirstName+' '+LastName AS Employee, tblEmployee.EID, SUM(GrossAmount) AS [2011 Gross], SUM(NetAmount) AS [2011 Net], SUM(GrossAmount) - SUM(...
I am writing simple sql queries but for some reason, I keep getting this error
"Msg 8152, Level 16, State 14, Line 1
String or binary data would be truncated.", I have no clue what's causing it and I have searched online what kinds of things would cause this error but all I found was "Yo...
Title varchar NOT NULL,
you need to give varchar a value
i.e.
book_desc varchar(50),
So basically the Title column only has a value of 1 character since you did not define it when creating your table and you are trying to insert more than 1 characters inside the column ...
@swasheck I found that if the reason that you chose for the bounty was: "One or more of the answers is exemplary and worthy of an additional bounty", then the 24 hours wait is superfluous
@swasheck maybe. I'm just frustrated that I have to simplify what I'm thinking...so I end up writing something that is not exactly what I was thinking (in spanish)
I'm a lot more articulated. So, you people could learn spanish!
I have a problem to strip out the format in a note table
Here is an example:
";\red31\green73\blue125;
\viewkind4\uc1\ltrpar\f0\fs20 USEFUL TEXT BODY \cf1\f3
\ltrpar\f0\fs17
"
How to get rid of those stuff? I want to play safe not to replace anything after'\'
Many thanks,
Rick
@billinkc ugh, the "smart quotes" replacement feature is one of the few remaining to-do items I have for perfecting formatting on our blog. Need to obliterate it.
INSERT INTO TEMP_TABLE (aNumber, aDate) VALUES ((aSproc param1, param2) , myDate)
I need to pass a stored procedure with parameters as a parameter of an insert statement. Is this possible?
You can't parse [X]HTML with regex. Because HTML can't be parsed by regex. Regex is not a tool that can be used to correctly parse HTML. As I have answered in HTML-and-regex questions here so many times before, the use of regex will not allow you to consume HTML. Regular expressions are a tool th...
However they are at least warm to the idea of fixing them. While wand was more concerned with putting all their efforts towards fucking up my accomplishments.
I achieved this by other means also . but prob with this approach is that it will have different name1 values for different records . my requirement is aa should be always name1 , 98 should be always name 2 , kki should be always name 3 so on . if records doesnt have wild cardswith name as aa for those name1 should be null similarly other fields with 1 also null as the record is not having a wildcard with aa. — Kuntady Nithesh10 hours ago
I noticed a question that demonstrated gross incompetence and mentioned some very specific unpopular frameworks in a certain combination that piqued my interest...
I invited the user to chat to talk about his problem and basically teach him basics...
@FreshPrinceOfSO i dont want to give too much proof ... but he just posted that question based on an im conversation we've been having on a classic asp application
i told him to take it to SO (mostly so that i could ferret him out)
I've really only just started playing with SQl and i really enjoy it. I'm in my very early 20's and I just left my job as an estate agent to pursue studying for the TSQL exams. .. I seem to have a problem though... I dont acctually know what kind of job im looking for to get a foot in the door in the industry. I know its not quite DBA stuff but I can find help anywhere.
unfortunately not. I live in the Uk and at this point in time its too tough. I understand DBA isn't what i should be looking at for a good 10 years but where do i start?
And got a recommendation. My career path was very convoluted. Restaurant worker -> restaurant manager -> Restaurant POS support person -> Helpdesk manager -> Data analyst -> SQL Developer
another option if you are excited about it is working on an open source project of some sort
@Lamak If I thought I could get away with it I would post a question and then a self-answer on how to pivot in each DB. But I think it wold get closed very quickly
I'm working on migrating an application from an IIS 6 to IIS 7.5 and am running into the weirdest issue:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/Complaints/Login.asp, line 175
...
I have an administrator table with admin users. I want them to be able to manually set a user account to be inactive using a function or stored procedure. How can I do that?
Oracle 11gR2 Exadata
I'm required to uniquely identify when records are created in time. Sequence caching means I cannot use a sequence-based ID and batching inserts means that all records inserted in one batch will have the same timestamp value (even using TIMESTAMP(9)). Akin to Twitter's sinc...
I am writing simple sql queries but for some reason, I keep getting this error
"Msg 8152, Level 16, State 14, Line 1
String or binary data would be truncated.", I have no clue what's causing it and I have searched online what kinds of things would cause this error but all I found was "Yo...
Title varchar NOT NULL,
you need to give varchar a value
i.e.
book_desc varchar(50),
So basically the Title column only has a value of 1 character since you did not define it when creating your table and you are trying to insert more than 1 characters inside the column ...
I have a problem to strip out the format in a note table
Here is an example:
";\red31\green73\blue125;
\viewkind4\uc1\ltrpar\f0\fs20 USEFUL TEXT BODY \cf1\f3
\ltrpar\f0\fs17
"
How to get rid of those stuff? I want to play safe not to replace anything after'\'
Many thanks,
Rick
INSERT INTO TEMP_TABLE (aNumber, aDate) VALUES ((aSproc param1, param2) , myDate)
I need to pass a stored procedure with parameters as a parameter of an insert statement. Is this possible?
reference..mfg_year_month_ww
is the short hand for
reference.dbo.mfg_year_month_ww
basically it means use default schema.
I have an administrator table with admin users. I want them to be able to manually set a user account to be inactive using a function or stored procedure. How can I do that?
