RE: Permission hierarchy
If it is a standard table then no. But if it is a temporary table prefixed with eiher # or ## then yes.
2005-05-04
dynamic data masking
Querying XML in SQL
I've been trying to figure out how to parse account information stored in a table in XML format. I was told i shoudl use ap_xml_preparedocument and i've attempted to use it with no luck....the original table looks like this:id xmlaccountinfo datetime1 <Account> <AccountInfo ... 2005-01-18 in greater detail here is a sample of the xmlaccountinfo:<Account> <AccountInfo DoCreditCheckOnly="1" DoCreateOnly="0" PrimaryPhoneAreaCode="123" […]
2005-03-16
Occasional error in my job
I run a job overnight everynight on both Production server and development machine. It never fails on the Production server but occasionally it fails on the development machine.Error:DTSRun OnStart: DTSStep_DTSActiveScriptTask_5 DTSRun OnError: DTSStep_DTSActiveScriptTask_5, Error = -2147220482 (800403FE) Error string: Error Code: 0 Error Source= Microsoft VBScript runtime error Error... Process Exit Code 1. The step failed.Any […]
2005-03-01
2 reads
RE: Overhead when using datatype varchar ?
I will make a note to look for that book, if you remember the title send me a message with it, thanks!Just to clarify, my client wants to use varchar because they said through experimentation, they discovered that their asp code was too slow when they had to add trim functions to database access (select?) […]
2005-02-24
RE: Cursor won''''t fetch next row?
More common, maybe, but does that necessarily mean it should be done that way? Why use two FETCH NEXT statements when you can easily use just one?
2005-02-14
15 reads
RE: How many platforms Do You Run at Home
5 platforms in all:WIndows XP --> for the kidsNT 4.0 Server --> SCSI II, RAID 5, SQL v7.0, Sybase ASE v12, Oracle v8, old work box (soon to be Win 2K3 Server)Win 2K Server --> SCSI II, RAID 1, SQL 2K, work connectity, etc.Win 2K3 Server --> SCSI II, RAID 1 & RAID 5 (build in progress)Solaris […]
2005-01-23
RE: problem with import data to sql server from csv files
if you know the number normally expected, do a charindex, loop up to that number, and if the next one comes back with a value, you've got the position.
2005-01-19
numeric data types in sql server
Whats the difference between int,float and decimal in sql server. WHich data type takes how many bytes?What data type i should use to store the following sets of data1set----100000,854275,74892734 2set----6538726.98765923,762.659325Thanks.
2005-01-17
1 reads
RE: SQL Server Registration Error Messages.....help?
I would try to uninstall SQL (as bad as that sucks) and re-install. When prompted, make sure you give SQL a valid SA password.I had the same problem. It took me installing and re-installing about 5 times before I could have a valid SQL server running from Enterprise Manager.
2005-01-17
SQL Mail Configuration, Works at first....
Hello. I'm having an issue setting up SQL Mail. My intent is to use it for notifications in DTS pacakges. I have configured the Mail control panel and outlook to use the mail profile and it works fine. I've sent and recieved e-mailss. However, when I try to test a MAPI session in Enterprise Manager […]
2004-12-06
2 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers