Hi, Yes you are right about WA authentication. It really creates a security problem more over i have the experoience of user opening the database using his login ID of Win 2k. So i always suggest to use the SQL security as its better than teh windows security.ThankxJeswanth
2004-07-01
Hi Ilijana,I am not familiar with omitting the database name but it seems that omitting the owner name enables the MS-data-access-oracle-unit (I think this is that MSDAORA) to find the table you want where as using "JZOB" as owner cause this unit to access a non existing object. As far as there are only one table IZDVOJENA_OR the second […]
2004-07-01
The better thing to do would be to find existing field(s) whose combination will define the entity that table is tracking. Then make that combination or single field a primary key. You kill 2 birds with one stone, 1) you separate attributes from entity definition, so it is easy to know what the table is for […]
2004-07-01
--Also, here's a script for you while I'm at it. DECLARE @int_counter INT, @int_max INT, @txt_name NVARCHAR(255), @txt_sql NVARCHAR(2500)DECLARE @databases TABLE ( int_id INT IDENTITY(1,1) PRIMARY KEY, txt_name NVARCHAR(255))INSERT @databases(txt_name) SELECT name FROM master..sysdatabases WHERE name NOT IN ('master','model','tempdb')SELECT @int_counter = (SELECT MIN(int_id) FROM @databases), @int_max = (SELECT MAX(int_id) FROM @databases)WHILE @int_counter <= @int_max BEGINSELECT […]
2004-06-21
Hi,Try change Aritmethic abort setting from connection property.1. Run SQL Server Enterprise Manager2.right klick on server, select properties3.select connection tab4. check mark on ANSI warning,ANSI padding,ANSI nulls, Aritmethic abort
2004-04-14
THANKS much !!! (Yes, it isn't that large a database when you think about, compared to the others we have on this system it is one of the largest).Obviously I need to do a couple of practice restores on dummy databases to get this down.My big concern was after 3 hours, and having no gauge […]
2004-03-31
Hi,I want to get the last occurance of a string/char in a given string.is there any implicit function for doing so similar to CAHRINDEX that returns the first occurance. Thanks in advance-Prasad
2004-03-25
1 reads
CONVERT(char(5),@dt,120)+RIGHT('0'+DATENAME(ww,@dt),2)
2004-03-24
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-03-22
This one puts the output into SQL commands that you can cut and paste into a new query and execute. -- af_revPermissions-- Verify existence of af_revPermissions procedure. If it does exist, -- drop it, so that it can be re-created. if exists (select * from sysobjects where id = object_id(N'[dbo].[af_revPermissions]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) begin […]
2004-03-18
By Rob Sewell
Whether you’re a developer at an agency or an aspiring creator, you can trust...
“Could you help me, we deleted the database’s transaction log file and now that...
I had a couple of clients who were moving content from development catalogs to...
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