|
|
Firstly thnx for your quick reply. And could you suggest a way in which the above error could be corrected. Even tried logging in as user:system. But it did not help. Same error.
|
|
|
|
|
Does Scott have 'create table' privileges?
|
|
|
|
|
Login with sys and whatever password you have, and set the correct correct privileges for user scott.
Or create a new user with the proper access rights for schema scott.
Or (this is from memory and might not be correct) add "SQLNET.AUTHENTICATION_SERVICES = (NTS)" into sqlnet.ora to be able to use NT security
|
|
|
|
|
I suppose it is unkind to laugh at people who are fumbling around with problems in technologies they do not understand, but this is a funny little exchange.
First: SQLNET.AUTHENTICATION_SERVICES has nothing to do with the person's problem.
Second: The person's error is quite self-explanatory.
Third: One wonders why he (or his helpers here) did not just Google the error message. The solution would have been quickly found.
The problem is that the person is either 1) trying to create a table in his own schema without having the CREATE TABLE privilege, or 2) trying to create a table in another schema without the CREATE ANY TABLE privilege. In addition, the user's account must have a quota on its default tablespace or have the UNLIMITED TABLESPACE privilege without one of which the ORA-01536 error will occur.
Kind regards,
Russ
|
|
|
|
|
'34523@#$@%^@^'
how can i find that above value contain special character in sqlserver 2005
|
|
|
|
|
in sql server 2000 you can use PATINDEX which will return the index of the given pattern, or you could use LIKE. If 2k5 has support for Regular Expressions you could use those, but i havent used 2k5 yet. We're going to upgrade to 2k8 shortly though.
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
I have Windows Server 2003 Enterprise OS, SQL 2005 Developer installled, And I am getting error with Web Synchronization with merge replication, I am stating here what i have done so till this time
- Configure a Publication with merge replication and pull subscription , Distributor & Publisher are on same machine, after Create a user Under Sysadmin Role, Create user for Publishing Database with db_owner schema, assign all permission to it,Running snapshot agent under SQL SERVER agent account, And for Web Synchronization I create account with DYNDNS.com and Create MyServer.dyndns.biz hostname with my static IP, And At publisher I assign address MyServer MyServer.dyndns.biz, configure web Synchronization at publisher as per Microsoft Site.
- At IIS I create a virtual directory under Default Web Site,named TestPublication,Create new user,IIS_user for IIS_WPG Group, Create new Application pool and Configure its identity with New Creted IIs_user,and set new application pool at my virtual directory application pool setting.At Default web site properties, I assign my static IP at WebSite Identification, At directory security tab,I enable anonymous access with "PINAAK-3\IUSR_PINAAK-3", select Basic authantication, Dafult domain as dyndns.biz, realm as MyServer.dyndns.biz, I create SSL trial with Thawte,but my IIS detected that there is not sufficient information available, and if i use self assigned cerificate with selfssl, At subcriber my IP cant be resolved,
- I create subcriber with pull subcription,give https://MyServer.dyndns.biz/TestPublication/replisapi.dll address,
running its agent under SQL server agent account.
I try web synchronization two times, first with https://***.**.**.***(My static IP)/TestPublication/replisapi.dll address, and configure all its related items as this address, create self ssl for that with static IP as its common name, At subcriber i get diagnosis window successful, and at authantication I gave MyServername\Administrator. But at second time login it ask again my UserName, Password.Here the problem is, at subcriber when i click View Subscrption status,"Specified File not found",error occured.
At second time I try with address https://MyServer.dyndns.biz/TestPublication/replisapi.dll, and this time also dignosis window is successful, but it ask me UserName, Password if i enter dignosis mode again. Here the problem is error "The Proxy Auto-configuration URL was not found.", comes.
|
|
|
|
|
Here is event log
**********************************************
This log comes to Subcriber job history, when address is
https://MyServer.dyndns.biz/TestPublication/replisapi.dll
-----------------------------------------------------------------------------------------------------------
a> Date 4/1/2009 8:29:27 PM
Log Job History
(PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0)
Step ID 1
Server PINAAK-1\PINAAK1
Job Name
PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0
Step Name Run agent.
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
The replication agent has been successfully started. See the Replication Monitor
for more information.
b> Date 4/1/2009 8:29:27 PM
Log Job History
(PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0)
Step ID 1
Server PINAAK-1\PINAAK1
Job Name
PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0
Step Name Run agent.
Duration 00:00:03
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
-XCancelEventHandle 00000414
2009-04-01 14:59:27.671 Connecting to Subscriber 'PINAAK-1\PINAAK1'
2009-04-01 14:59:27.812 Connecting to Subscriber 'PINAAK-1\PINAAK1'
2009-04-01 14:59:27.843 The upload message to be sent to Publisher
'PINAAK-3\PINAAK3' is being generated
2009-04-01 14:59:27.843 The merge process is using Exchange ID
'3148BDDD-384E-4F63-9EC6-A596612FDCE5' for this web synchronization
session.
2009-04-01 14:59:30.421 The Proxy Auto-configuration URL was not found.
2009-04-01 14:59:30.421 Category:NULL
Source: Merge Process
Number: -2147209324
Message: The Proxy Auto-configuration URL was not found.
2009-04-01 14:59:30.421 Category:NULL
Source: Merge Process(Web Sync Client)
Number: -2147023888
Message: The Merge Agent could not connect to the URL
'https://pinaak3.dyndns.biz/TestPublication/replisapi.dll' during Web
synchronization. Please verify that the URL, Internet login credentials and proxy
server settings are correct and that the Web server is reachable.
c> Date 4/1/2009 8:29:27 PM
Log Job History
(PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0)
Step ID 1
Server PINAAK-1\PINAAK1
Job Name
PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0
Step Name Run agent.
Duration 00:00:03
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: Pinaak-1\Administrator. The replication agent encountered a
failure. See the previous job step history message or Replication Monitor for more
information. The step failed.
d >
Date 4/1/2009 8:29:27 PM
Log Job History
(PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0)
Step ID 0
Server PINAAK-1\PINAAK1
Job Name
PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0
Step Name (Job outcome)
Duration 00:00:03
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
The job failed. The Job was invoked by User sa. The last step to run was step 1
(Run agent.).
-------------------------------------------------------------------------------------------------------------
This log comes to Subcriber job history, when address is
https://MyServer.dyndns.biz/TestPublication/replisapi.dll
-------------------------------------------------------------------------------------------------------------
a>Date 4/1/2009 8:46:49 PM
Log Job History
(PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0)
Step ID 1
Server PINAAK-1\PINAAK1
Job Name
PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0
Step Name Run agent.
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
The replication agent has been successfully started. See the Replication Monitor
for more information.
b> Date 4/1/2009 8:46:49 PM
Log Job History
(PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0)
Step ID 1
Server PINAAK-1\PINAAK1
Job Name
PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0
Step Name Run agent.
Duration 00:00:03
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
-XCancelEventHandle 00000440
2009-04-01 15:16:49.562 Connecting to Subscriber 'PINAAK-1\PINAAK1'
2009-04-01 15:16:49.687 Connecting to Subscriber 'PINAAK-1\PINAAK1'
2009-04-01 15:16:49.734 The upload message to be sent to Publisher
'PINAAK-3\PINAAK3' is being generated
2009-04-01 15:16:49.765 The merge process is using Exchange ID
'525DD6A9-1A59-4D2B-9DD4-4DE48BA5FDBC' for this web synchronization
session.
2009-04-01 15:16:52.125 The Proxy Auto-configuration URL was not found.
2009-04-01 15:16:52.125 Category:NULL
Source: Merge Process
Number: -2147209324
Message: The Proxy Auto-configuration URL was not found.
2009-04-01 15:16:52.125 Category:NULL
Source: Merge Process(Web Sync Client)
Number: -2147023888
Message: The Merge Agent could not connect to the URL
'https://219.64.82.212/TestPublication/replisapi.dll' during Web synchronization.
Please verify that the URL, Internet login credentials and proxy server settings are
correct and that the Web server is reachable.
c > Date 4/1/2009 8:46:49 PM
Log Job History
(PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0)
Step ID 1
Server PINAAK-1\PINAAK1
Job Name
PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0
Step Name Run agent.
Duration 00:00:03
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: Pinaak-1\Administrator. The replication agent encountered a
failure. See the previous job step history message or Replication Monitor for more
information. The step failed.
d>
Date 4/1/2009 8:46:49 PM
Log Job History
(PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0)
Step ID 0
Server PINAAK-1\PINAAK1
Job Name
PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0
Step Name (Job outcome)
Duration 00:00:03
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
The job failed. The Job was invoked by User sa. The last step to run was step 1
(Run agent.).
+++++++++++++++++++++++++++++++++++++++++
Here is th log at System Event Log
--------------------------------------------------------------------------------------------------------------
Event log:
SQL Server Scheduled Job
'PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0'
(0x3710058FCC349B479E94B09297DF0AF4) - Status: Failed - Invoked on:
2009-04-01 20:35:30 - Message: The job failed. The Job was invoked by User
sa. The last step to run was step 1 (Run agent.).
22>>
DCOM was unable to communicate with the computer PINAAK-3 using any of the
configured protocols.
The certificate received from the remote server was issued by an untrusted
certificate authority. Because of this, none of the data contained in the certificate
can be validated. The SSL connection request has failed. The attached data
contains the server certificate.
33>>
SQL Server Scheduled Job
'PINAAK-3\PINAAK3-PubTest-TestPub-PINAAK-1\PINAAK1-WebSynch- 0'
(0x3710058FCC349B479E94B09297DF0AF4) - Status: Failed - Invoked on:
2009-04-01 20:31:40 - Message: The job failed. The Job was invoked by User
sa. The last step to run was step 1 (Run agent.).
Here Pinaak-3 is Publisher server, Pinaak-1 is subcriber server.
|
|
|
|
|
1. How can i get the first letter from name column
|
|
|
|
|
By using the SubString [^] function on the column.
It's usage;
SELECT SUBSTRING([column-name goes here], StartIndex, Length)
An example;
SELECT SUBSTRING([text], 1, 4)
FROM master.dbo.syscomments
You would require;
SELECT SUBSTRING([name], 1, 1)
Good luck
I are troll
|
|
|
|
|
This query return first letter of table's column name
SELECT substring(column_name,1,1) FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = 'TableName'
Or do you want to get first letter of values in one column?
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
|
hi,
is there anyway to set programaticly a connection to ms access .mdb file so the culture info in the connection would "en-us" or example if windows set to germany culture info ( dates are like 10.9.1982 )
i would like to insert rows through .net framework which contains dates in en-us format all the time and so acceess db would be able to parse them ,
or any alternatives?
thanks
Net
|
|
|
|
|
If you're using ODBC, then you might be able to do this through the connectionstring, by setting the locale-identifier. Take a look at the last entry on this page[^] for an example.
I are troll
|
|
|
|
|
im using OLEDB my current connection string looks something like this:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\data\Demo.wwdb
any known way for oledb i couldnt find
Net
|
|
|
|
|
Hi,
I am trying to configure replication between 2 SQL Server 2005 databases located on seperate Windows servers, but because the subscriber cannot see the shared snapshot folder at the publisher, I want to use an FTP folder instead.
I have read Microsoft's documentation on this but have gotten a bit stuck! Microsoft say to specify the default snapshot folder in the distributer properties, but it won't let me enter an FTP url, only a UNC path. Can someone tell me how do I specify a UNC path to a FTP folder in the distributor properties?
This is what I have been reading from Microsoft http://msdn.microsoft.com/en-us/library/ms151844(SQL.90).aspx[^]
Thanks in advance
|
|
|
|
|
Nevermind people, got it sorted thanks
|
|
|
|
|
I have a strange problem with a Linked Server and believe it to be caused by a configuration issue somewhere, but not sure where.
I have added a Linked Server from my AdminSQLServer to my TELEMETRY server. Both servers are running MS SQL Server 2005 Standard and are in the same building on two separate networks which are linked together via firewalls (which I believe are configured correctly).
In SQL Server Management Studio is I try a simple query like SELECT * FROM TELEMETRY.Collections.dbo.Accounts I get the following errors :-
OLE DB provider "SQLNCLI" for linked server "TELEMETRY" returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "TELEMETRY" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".
Msg 53, Level 16, State 1, Line 0
Named Pipes Provider: Could not open a connection to SQL Server [53].
Strangely enough, if I then connect to the TELEMETRY server within Management Studio then execute the query above again, it works fine.
I also have another linked server in a building 100 miles away, from which I can get results from every time without fail.
Any pointers/help greatly appreciated (I'm taring my hair out )
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
Sounds like some sort of routing issue (if the login/password in the linked server is fine and good).
While you may be able to ping the Telemetry server from the first sql server, this isn't necessarily an indicator if traffic can make the round trip there and back.
The Tetlemetry server or it's firewall or other network hop along the way, might be trying to send the traffic back to server A, along a different path.
Do a tracert at the command line for each server and this may shed some light on things. If you have some network support, they should be able to identify the problem pretty quickly using the tracert data.
|
|
|
|
|
Good Day all.
I have the Following Query
SELECT T.ID, T.CYCLETEMPLATES
FROM TBL_TERM T
This Brings back something like this
ID CycleTemplate
==============================================================
5 | 1010101010101000100010101010100010000000000000000000
6 | 1000000000000000000000000000000010000000000000000000
Now i have another table Defined like this
CREATE TABLE DBO.REC_TERM_CYCLE
(
ID INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
TERM INT NULL,
CYCLE VARCHAR(10) NULL
)
Let me explain the Logic of a Cycle template,
1010101010101000100010101010100010000000000000000000
The "1"'s represent the position of the template. if i can return this, it will bring me
1,3,5,7,9,11,12,16 ................
So i want to run an Insert statement on the table REC_TERM_CYCLE like this
INSERT INTO DBO.REC_TERM_CYCLE
VALUES(ID,cycles)
Now the Cycles are the individual number retrieved from that long string. but now this must go to a table to retrieve the Cycles Template long string and add the id and the position of the cycle
i have the below code
SELECT T.ID, T.CYCLETEMPLATES
FROM TBL_TERM T
Declare @Len int
SET @Len = LEN(T.CYCLETEMPLATES)
Declare @Counter int
SET @Counter = 1
WHILE @Counter < = @Len
BEGIN
if (SUBSTRING(T.CYCLETEMPLATES,@Counter,1)='1')
INSERT INTO DBO.REC_TERM_CYCLE
VALUES(T.ID,@Counter)
SET @Counter = @Counter + 1
END
PRINT 'INSERTED' + T.ID '' + @Counter ''
Thanks
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
modified on Wednesday, April 1, 2009 6:07 AM
|
|
|
|
|
I got a Solution, and the Solution was that i have to create a Function like this
CREATE FUNCTION [dbo].[f_GenerateRows]
(@NumRows INT)
RETURNS
@Tbl TABLE (pkID INT PRIMARY KEY NOT NULL)
AS
BEGIN
DECLARE @i INT;
-- SELECT * FROM dbo.f_GenerateRows((SELECT 10))
SET @I = 1
WHILE @I <= @NumRows BEGIN
INSERT INTO @Tbl VALUES(@I)
SET @I = @I + 1
END
RETURN
END
After that i have to do my insert like this in another SP
ALTER PROC sp_Create_Staff_Cycle_Clash
AS
--CHECK IF THE TABLE EXISTS
IF NOT exists(select * from sys.databases where name = 'REC_TERM_CYCLE')
BEGIN
EXEC CREATE_TABLE_REC_TERM_CYCLE
END
ELSE
BEGIN
TRUNCATE TABLE DBO.REC_TERM_CYCLE
DECLARE @ROWS int
SET @ROWS = (SELECT COUNT(*) FROM tbl_term)
INSERT INTO REC_TERM_CYCLE (term, cycle)
SELECT t.ID, i.pkID
FROM TBL_TERM AS t
CROSS JOIN dbo.f_GenerateRows(@ROWS) AS i
WHERE SUBSTRING(t.CYCLETEMPLATES, i.pkID, 1) = '1'
ORDER BY t.ID, i.pkID
END
now this Works fine, but i wanted to check First if the table exists before i work on it, now if the table exists and i run this sp i get the Following error
Msg 2714, Level 16, State 6, Procedure CREATE_TABLE_REC_TERM_CYCLE, Line 4
There is already an object named 'REC_TERM_CYCLE' in the database.
Please help
Thank you
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
www.ITS.co.za
|
|
|
|
|
Hi,
I have created a database, and I want to populate it with some demo data so that I can test my queries for optimisation. I want a program that creates me something where I can insert data, lots of data. Anything out there that is free?
Thanks
|
|
|
|
|
Have you ever considered mastering the arcane art of Googling.
I Googled 'test data generator', and got hundreds of hits.
Go on, give it a go! You know you want to.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
SELECT TO_TIMESTAMP ('10-Sep-02 14:10:10.123000', 'DD-Mon-RR HH24:MI:SS.FF')
FROM DUAL;
|
|
|
|
|