RE: log file
In the index in SQL Server Books On Line type the following "DTS packages, logs" and that should get you started. Hope this helps. David
2003-07-08
1 reads
Licensing
RE: Rights Accross Databases
I was hoping to avoid refering a view, but in any case wouldn't the view suffer the same problem since it's accessing objects from the other database? ... just tried it and I still get this error: Server: Msg 229, Level 14, State 5, Line 1 SELECT permission denied on object 'Tblxxx', database 'xxx', owner […]
2003-07-02
2 reads
RE: Rights Accross Databases
I tend to create a view in the first database to access the second. Helps if I need to move things by abstracting. Also doesn't tie my code to some database name (other than the view). Same security items brought up above still apply. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-07-02
1 reads
RE: Locking problem
We also have seen differences between SQLServer 7 and 2000. We looked for the differences with the profiler on both servers (And sqlserver 2000 with 70 compatibility) looking using sql statements, stored procedures , RPC's (used by our centura application and I have heard also by ADO) and locks. Save the results to text files […]
2003-07-02
RE: Rights Accross Databases
Not if all objects are owned by the same owner. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-07-02
1 reads
RE: Handling "optional fields"
quote: When one customer is modifying their extended table, would we see locking issues on the primary table for customers other than the one modifying the extended table? No, SQL Server implements row-level lock. Looking at your keys, I don't believe this would be an issue. quote: Also, this would mean that all my select […]
2003-06-17
RE: DTS and INSERT Triggers
Thanks Everett! I will give it a try later in the week when they get data back into the Oracle database and let you know if that did the trick. Jason
2003-06-16
RE: Handling "optional fields"
Personally, I think 2 is actually your best option. The cons that you outlined I don't see as drawbacks, actually. You can easily add powerful join indexing simply by adding a mandatory index on each extended table on its foreign key: --Main Table Sample: CREATE TABLE MainTable ( accountID INT NOT NULL , recordID INT […]
2003-06-16
RE: HELP!!
Hi, You could use the REPLACE function to replace the carriage returns with a blank space... SELECT REPLACE(REPLACE(FieldName,Char(13),''),Char(10),'') from TableName The Char(10) and Char(13) should take care of the new line and carriage return values in the field... If the field in question is of "text" type then you will have to use the UPDATETEXT […]
2003-06-16
RE: New Feature
As long as people learn, I sure don't care. You can live with your score being high artificially Brian Knight bknight@sqlservercentral.com http://qa.sqlservercentral.com/columnists/bknight
2003-06-15
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
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