There might be a cleaner way to do this -- I just kind of dashed it off -- and I apologize for the bad variable names, but I'm too lazy to change them now ... But here's one way w/ no dynamic SQL: declare @x varchar(20) set @x = '0xFFFA01' set @x = right(@x, len(@x) […]
2005-04-20
Currently we are running a current version of Microsoft SQL Server 2000 at the patch level of 3a. I am getting hold of the BETA version of 4.I am not sure to apply this patchset 4 and whether it will cause problems if we next time move forward to upgrade to YUKON, SQL Server 2005 […]
2005-04-06
You can choose from the following:either SQL Profiler Trace or you can use some third party tools lke logexplorer or LogPI etc. Or you can change you C2 Audit level at your server.Thanks
2005-04-06
I think the correct answer really is NONE OF THE ABOVE. Your first step really should be to determine what the security requirements are. Otherwise, you will simply launch Analyis Manager and then what access to you give to this user ?
2005-04-06
I am confused between answer A and D. What would be the best answer and why?Q.You are the database developer for your company`s Accounting database. The database contains a table named Employees. Tom is a member of the Accounting department. Tom`s database user account has been denied SELECT permissions on the salary and BonusPercentage columns […]
2005-04-04
2 reads
Has anyone been able to make the "Importance" or "Priority" work using CDOSYS ?
2005-03-24
Hi,Please make sure that you don't have any empty spaces. Did you check the database compatibility. Hope it is 80.If the database compatibility is 60,65,70 then probably you have some other setting to look for. I've noticed that if you specify a nonexistent database name, it returns an empty result set instead of returning an error […]
2005-03-17
1 reads
More questions than answers for starters:10k or 15 K disks ? what size ? smart array disk controllers or the builtin ? if smart array controllers, how much memory ? what is the database size (data/log) ? how many users ?
2005-03-11
I have SQL tables linked to an Access database, which I use as a front end. The user enters start and end dates, then a VBA module to run a pass-thru query that kicks off a stored procedure on the server. The stored procedure truncates a SQL Server table, then refreshes it with information for the user selected date range. My question is this: After running […]
2005-02-23
1 reads
Finally it works again!Yes I think that my both servers where rebooted in tens times. Don't as me what concrete I've done, you wouldn't get an answer because I don't know. I can only guess that removing registries and installing a local copy of sql server with the same named instance name and then removing […]
2005-02-18
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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