Interesting. I've run into the issue with single NIC/single IP, but NT auth works with named pipes. However since it's disabled with most servers (sockets only), it was blind luck we figured that out.It started when we changed the service ccount. I read Chad Miller's article and suspected rights on the service account (domain user, […]
2004-03-26
sorry abv 1210 has type "Oper" onlyi wrongly typed two different values.now 1210 should not b listed.i want only master records that r type "Avail" and "Oper"Thanks
2004-03-25
This should do it but might be a better way I didn't see.SELECT x1.master, x1.type FROM tblX x1 INNER JOIN ( SELECT x2.master, x2.type t1, x3.type t2 FROM tblX x2 INNER JOIN tblX x3 ON x2.master = x3.master WHERE x2.type = 'avail' and x3.type = 'oper' ) o1 ON x1.master = o1.master and x1.type in […]
2004-03-25
I have not seen any other tool as you need. The biggest problem with tools like Access and the reason they perform so badly is the way they read the data and all views and functions designed on the local copy execute within that environment not pushed out to run against SQL so the data […]
2004-03-24
I have also done it before using temp tables with a identity field. The purpose of the post above was someone needed it in a straight select statement. Thanks for the reply!
2004-03-23
OK, next question:I built a view to test using the above udf and this works:SELECT mail, sn, givenname FROM dbo.udf_GetEMpsBYManager('115898') udf_GetEMpsBYManagerNow, I don't want to be hardcoding employeeid's so I wrote a scalar udf, udf_GetEmployeeID that takes a full or partial name and returns a 6 character employeeid. I tried to code that into the […]
2004-03-23
Erm.. Is there a learge difference in Data size.Our developement DB's have minimal data. We only use similar size DB's on Test DB's
2004-03-23
If you are looking to return just the items despatched during the last calendar month, try using something like this:where oh.date_despatched between convert(char, dateadd(mm, -1, dateadd(dd, -(day(getdate()) - 1), getdate())), 112) and convert(char, dateadd(dd, -day(getdate()), getdate()), 112)This calculates the 1st day of the preceeding month and the last day of the preceeding month with no […]
2004-03-23
At what time was your last log backup?
2004-03-22
I appreciate your reply. We have plenty of new apps. in the works and a few "hot out of the oven" so you could be smelling a few different things. But for now I am interested in how the market is being served in the area of sql server encryption. Password, database and data - but not necessarily […]
2004-03-21
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
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