SELECT column_name name, constraint_name name FROM '+@destination_DatabaseName+'.information_schema.key_column_usage WHERE constraint_catalog='''+@destination_DatabaseName +''' and table_name = '''+@destination_TableName+''' ORDER BY constraint_name, ordinal_position
2004-02-06
1 reads
Why can't my query update a linked table? I have a query in MS Access that has a linked (ODBC) SQL Server table as it's source. To get the results I need the query uses three separate fields for criteria. The query returns the correct data set, however when any data is changed / updated […]
2004-02-06
2 reads
Thought others might benefit from Mary Chipman's comments (from newsgroup):An mdb is a better choice since you also have the flexibility of storing static data locally in Jet tables, allowing you to decrease round trips across the network to fetch data that rarely changes. You can't update the results of a pass-through query, and that […]
2004-02-04
1 reads
Chris,Excellent article!!! After reading your article, I checked w/ our Sr. System Developer to verify if we are using these techniques. We are looking in depth to other exploitations of SQL injections with our app.Thanks,Dave S.
2004-02-03
I'd have to agree that not having anyone administer the SQL Server is a recipe for disaster. Despite it being easy to do, or relatively easy, you still need a DBA to perform work, watch the server and ensure that it is running well. This can be a sysadmin, a full time DBA, or a […]
2004-02-03
I once got initial FT problems because I'd removed the builtin/administrators login.
2004-02-03
I posted a reply last week, am sure I saw it here for a while but now gone. From quick google search I believe this behavior is MDAC dependent, so only safe way to proceed would probably be something like this "if @@transcount > 0 commit" whenever you make modifications w/in OpenRowSet. It bothers me […]
2004-02-02
2 reads
Ain't date handling marvellous? All sorts of ways of "skinning the cat". My approach to getting the first day of the month and first of the next is as follows ... (I always use alpha for the month ... saves confusion).declare @today datetime select @today=getdate()select '01 '+substring(convert(char(11),@today,106),4,11), '01 '+substring(convert(char(11),dateadd(month,1,@today),106),4,11)01 Feb 2004 01 Mar 2004
2004-02-02
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-02-02
Saving the scripts and applying it to your databases like Jonathan suggested, sounds pretty obvious to me.If you have several databases with the same structure, I would create my own rollout and maintainance routines. In the end you'll need them away.Another question:PRIMARY_KEY varchar (512) ?What are you storing there?
2004-02-02
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