Any Idea What This Means .....?

Nov 7, 2007



Hi,

Does anyone have any idea waht this means:

aspnet_wp!resourceutilities!5!07/11/2007-10:32:00:: i INFO: Reporting Services starting SKU: Developer
aspnet_wp!resourceutilities!5!07/11/2007-10:32:00:: i INFO: Evaluation copy: 0 days left

It is take from the ReportServer log file.

Thanks in advance for any response.

Jon

View 1 Replies


ADVERTISEMENT

Just An Explanation Of What This Means Please

Jan 22, 2008

Hi,
I have a project that has been given to me and need help please. The complete class is as follows
Public Class CarAccessData
    Public Function Getcarinfo() As List(Of CarInfo)
        Dim AllCarInfo As New List(Of CarInfo)
        Dim SQL As String        SQL = "SELECT [SKU], [CarMake], [CarModel], [Carprice]"
        Dim MyConnection As SqlConnection        MyConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("AntConnectionString1").ConnectionString)
        Dim aCmd As SqlCommand        aCmd = MyConnection.CreateCommand
        aCmd.CommandText = SQL        aCmd.CommandType = CommandType.Text
        Dim aDataReader As SqlDataReader
        Try
            MyConnection.Open()
            aDataReader = aCmd.ExecuteReader
            While aDataReader.Read()
                AllCarInfo.Add(New CarInfo(aDataReader))            End While
        Catch ex As Exception            Throw ex        Finally
            aDataReader.Close()
            MyConnection.Close()        End Try
        Return AllCarInfo    End Function
End Class
 
The bit I dont quite understand is the following snippet from above
 
 
Dim aCmd As SqlCommand        aCmd = MyConnection.CreateCommand
        aCmd.CommandText = SQL        aCmd.CommandType = CommandType.Text
        Dim aDataReader As SqlDataReader
        Try
            MyConnection.Open()
            aDataReader = aCmd.ExecuteReader
            While aDataReader.Read()
                AllCarInfo.Add(New CarInfo(aDataReader))            End While
        Catch ex As Exception            Throw ex        Finally
 
Can anyone explain this in real ABC style step by step please, just so I can start to understand this, ( I am quite new to this)
many thanks,
Anteater

View 8 Replies View Related

Can U Tell Me What This Error Means?

Jul 12, 2002

I am using ODBC to access MS Sql Server 2000 Enterprise(& Prof.) Edition. While running some queries, I occassionaly get following error :-
Error Text : [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send())"
Error No : 10054
Source : Microsoft ODBC driver for SQL Server" as source.
IMO, Its not related to specific query as I get it for different queries at different time and its infrequent.
I have found a MS KB article for the error that says this error is possible in long queries if lightweight pooling (fiber mode) setting is enabled for SQL Server and the fix is to use SP2. I am already running with SP2 installed.
I could not find another reference to this error. And as I am unable to locate cause of problem, I am not able to troubleshoot it. Any help will be appreciated.

Thanks.

View 1 Replies View Related

Cluster Means

Oct 20, 2007

Hi listers,
in cluster_algorithm is possible to extract the information of 'cluster profile' like mean and StdDev into a new table?

Any suggestion would be very appreciated.

Thanks in advance

Cristiano

View 5 Replies View Related

Instance Means...

Mar 28, 2007

In oracle The simplest description of instance : combination of memory and process architecture



I sql server, what is the Instance.? it is combination of memory and process architecture if yes then pls give name those processes ?

View 3 Replies View Related

What This Error Means And How To Solve It!!

Aug 15, 2007



Hi,

I have report server in SharePoint integrated mode and the Reporting services runnign under domain account. which is part of dmain adming group as well.but when i try to connect to http:\localhost
eportserver

it gives me this error:
Reporting Services Error



Report Server has encountered a SharePoint error. (rsSharePointError) Get Online Help

User cannot be found.


SQL Server Reporting Services


and in reporting service log it gives me following information
w3wp!webserver!1!8/15/2007-13:40:01:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error. ---> Microsoft.SharePoint.SPException: User cannot be found.
at Microsoft.SharePoint.SPUserCollection.GetByID(Int32 id)
at Microsoft.SharePoint.SPWeb.get_Author()
at Microsoft.ReportingServices.SharePoint.Server.Utility.GetSPWebProperties(SPWeb web)
at Microsoft.ReportingServices.SharePoint.Server.SharePointDBInterface.internalFindObjectsNonRecursive(String wssUrl, CatalogItemList& children)
at Microsoft.ReportingServices.SharePoint.Server.SharePointDBInterface.FindObjectsNonRecursive(String wssUrl, CatalogItemList& childList, Security secMgr, IPathTranslator pathTranslator, Boolean appendMyReports)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.SharePoint.Server.SharePointDBInterface.FindObjectsNonRecursive(String wssUrl, CatalogItemList& childList, Security secMgr, IPathTranslator pathTranslator, Boolean appendMyReports)
at Microsoft.ReportingServices.Library.ListChildrenAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderFolder()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()

how can I solve it!!!!!

thanks

View 12 Replies View Related

Understanding What This Dts.Pipeline ERROR Means

Feb 26, 2006

Im am pulling down table called PRV from another server throught an ODBC connection in my SSIS package. I have the source and destination task all set up. I get this error when i run the packag. Most of the time, the error is pretty self explanatory but this one is .....beyond me. Any ideas.

Error: 0xC02090F5 at PRV TABLE FROM CYPRESS, PRV SOURCE [1]: The component "PRV SOURCE" (1) was unable to process the data.
Error: 0xC0047038 at PRV TABLE FROM CYPRESS, DTS.Pipeline: The PrimeOutput method on component "PRV SOURCE" (1) returned error code 0xC02090F5. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
Error: 0xC0047021 at PRV TABLE FROM CYPRESS, DTS.Pipeline: Thread "SourceThread0" has exited with error code 0xC0047038.
Error: 0xC0047039 at PRV TABLE FROM CYPRESS, DTS.Pipeline: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.
Error: 0xC0047021 at PRV TABLE FROM CYPRESS, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0047039.
Information: 0x40043008 at PRV TABLE FROM CYPRESS, DTS.Pipeline: Post Execute phase is beginning.
Information: 0x402090DF at PRV TABLE FROM CYPRESS, PRV Destination [4076]: The final commit for the data insertion has started.
Error: 0xC0202009 at PRV TABLE FROM CYPRESS, PRV Destination [4076]: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Arithmetic overflow occurred.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Arithmetic overflow error converting IDENTITY to data type smallint.".
Information: 0x402090E0 at PRV TABLE FROM CYPRESS, PRV Destination [4076]: The final commit for the data insertion has ended.
Error: 0xC0047018 at PRV TABLE FROM CYPRESS, DTS.Pipeline: component "PRV Destination" (4076) failed the post-execute phase and returned error code 0xC0202009.
Information: 0x40043009 at PRV TABLE FROM CYPRESS, DTS.Pipeline: Cleanup phase is beginning.
Information: 0x4004300B at PRV TABLE FROM CYPRESS, DTS.Pipeline: "component "PRV Destination" (4076)" wrote 113136 rows.
Task failed: PRV TABLE FROM CYPRESS

View 3 Replies View Related

Primary Key Means It Should Not Accept Null Values Is It?

Sep 15, 2004

Friends,

I am inserting a value from vb.net to sql server 7.
i created a table in the sqlserver with primary key.
In VB.net form i didnt check the values of the check box.
when i try to save the empty or null the sql server should throw the error. but its accepting the null value.
how is it possible?
can anyone help me?
FYI:
table name: JobMast
Fields:
jobcode int primary key
jobtitle varchar(10)

View 12 Replies View Related

How Trustworthy Is Sys.partitions As A Means For Counting Rows In A Table?

Nov 20, 2007



Hi all,
I have the following function:




Code Block
create function udf_CountRows(@pTableName sysname)
returns int
as
begin
declare @ret int

select @ret = SUM(p.rows)
from sys.partitions p
inner join sys.objects o
on p.object_id = o.object_id
and o.[name] = 'Well'

return @ret
end





Can I trust sys.partitions to always return the correct value or does it suffer the same issue as sysindexes prior to SQL2005?

Thanks
Jamie

View 5 Replies View Related

Explain What This Error Message Means, Please....In Report Builder!

May 15, 2008

An error has occurred during report processing.

Query execution failed for data set 'dataSet'.

Semantic query execution failed. Too many table names in the query. The maximum allowable is 256. Incorrect syntax near the keyword 'AS'. Incorrect syntax near the keyword 'AS'. Incorrect syntax near the keyword 'AS'. Incorrect syntax near the keyword 'AS'. Incorrect syntax near the keyword 'AS'. Incorrect syntax near the keyword 'AS'. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.

View 1 Replies View Related

I’m Getting This Error When Checking Out A Report From Visual Source Safe…any Clue As To What It Means?

Mar 22, 2007

Originally got this error as the reason some of my .rptproj files could not be converted from SRS 2000 to 2005.  Now I€™m getting this error when checking out a report from Visual Source Safe 6.0€¦any clue as to what it means?

Project item '4294967294' does not represent a file.

This is for a solution created and stored in VSS using VS2003 and SRS 2000.  Now trying to open with VS 2005.

View 2 Replies View Related

Any Idea?

Mar 4, 2008

i have a table FORUM_REPLY it contain follwing fieldsquest_id,answer_id, reply_user_id.i want who is post most answer.so i need reply_user_id and max(no_of_answer).but following query given reply_user_id and no_of_answer onlySELECT reply_user_id,count(answer_id) as no_of_answer FROM FORUM_REPLY  GROUP BY(reply_user_id)How to get max_no_of_answer? 

View 13 Replies View Related

Can A DTS Do This For Me , If So, Any Idea How?

May 21, 2001

Hi all,

I am new to the DTS game - or at least to trying to do anything other than transfer rows between databases with identical structures.

I now need to create a far more complex DTS package to transfer data between an SQL Server database (I am using SQL Server 7.0) and an Oracle database. I have no trouble in making the connections and performing simple DTS's beween the two.

However, my current task is more complicated.

Problem 1:
In one database I would store fifty values as 5 five records each containing 10 values (i.e. has ten fields). However, in the other database these fifty values would all be stored as one record (i.e. one row with 50 fields). How could I go about creating a DTS to transfer this information?

Problem 2:
These values should only be transfered if certain conditions are met in an another unrelated table. For example, a flag in another table indicating that transfer of the said values should occur.

Any help with either of these problems would be much appraciated.

Thanks in advance,
Ross

View 3 Replies View Related

Any Idea's On 605

Nov 16, 2000

When one of the users log into the database via a thrid party application
they receive an error message:

2000/11/16 10:40:13.84spid51Error : 605, Severity: 21, State: 1
2000/11/16 10:40:13.84spid51Attempt to fetch logical page 7832 in database 'highview' belongs to object '1241055457', not to object 'application_data'.
2000/11/16 10:45:07.68spid46Getpage: bstat=0x1008/0, sstat=0x80002110, disk
2000/11/16 10:45:07.68spid46pageno is/should be:objid is/should be:
2000/11/16 10:45:07.68spid460x1e98(7832)0x49f900e1(1241055457)
2000/11/16 10:45:07.68spid460x1e98(7832)0x4810b86f(1209055343)
2000/11/16 10:45:07.68spid46... extent objid 0, mask 0/0, next/prev=0/0
2000/11/16 10:45:07.68spid46... retry bufget after purging bp 0x2da7e060


I tried running DBCC checkdb, newalloc,& checktable to fix the probelm and than droping the table and rebuilding it but not success, any suggestion are
more than welcome.

View 1 Replies View Related

Need An Idea How To....

Jun 21, 2002

If anybody can suggest the most efficient way to "page" the output from a big and wide table (about 7000000 records) in order to display on the web in the user requested sort order. Sort order could be on at least 7 different columns from 50 of returned.

I need to find a solution to move to the next and previous page.

Any Idea?

Dim

View 2 Replies View Related

Just An Idea

Jul 23, 2004

what if I took this trigger and based it on a view rather then a table

CREATE TRIGGER TerminationUpdateTrigger ON EmployeeGamingLicense
FOR UPDATE
AS
INSERT INTO TERMINATION(Status,[TM #],LastName, FirstName, [SocialSecurityNumber], DateHired, Title)
SELECT STATUS, [TM#], LASTNAME, FIRSTNAME, [SSN#], HIREDATE, JOBTITLE
FROM Inserted
WHERE STATUS = 'TERMINATED'


CREATE VIEW dbo.Update_Terminations
AS
SELECT STATUS, TM#, LASTNAME, FIRSTNAME, SSN#, HIREDATE,
JOBTITLE
FROM dbo.EmployeeGamingLicense
WHERE (STATUS = N'TERMINATED')

Base the Trigger on this View rather then on the Table itself????

View 2 Replies View Related

Some Idea

Apr 27, 2008

Hi I'm new to sql and it would be great if someone could give some idea on how to do the following

This is the relational model:

Department(DeptNum, Descrip, Instname, DeptName, State, Postcode)
Academic(AcNum, DeptNum, FamName, GiveName, Initials, Title)
Paper(PaNum, Title)
Author(PaNum, AcNum)
Field(FieldNum, ID, Title)
Interest(FieldNum, AcNum, Descrip)



The question is :-
Which academics have the largest number of fields of interests? Return their academic number,
given name, family name, institution and total number of fields they are interested in. Your must use a
subquery in the sense that you must use 2 sql statements and use any of the following to connect both:-


1)Exists
2)Not exists
3)IN

View 5 Replies View Related

Someone Have Any Idea About It?

Sep 18, 2006

I have a table call CLIENTE and another table call ENDERECO where the CLIENTE table has the FOREIGN KEY of the ENDERECO table.

When I try INSERT COMMAND in C# this message is show.

The instruction INSERT conflicted with a constraint of FOREIGN FUNDAMENTAL "FK_CLIENTE_ENDERECO." The conflict happened in the database "E:ARQUIVOS DE PROGRAMASMICROSOFT SQL SERVERMSSQL.1MSSQLDATALINETEC.MDF", table "dbo.I ADDRESS", column 'IDENDERECO.'
The instruction was concluded.

I am a "little" lost.

Thanks.

View 3 Replies View Related

Do Anyone Have An Idea?

Mar 21, 2007

Hi there,



I have number of tasks in my control flow most of them are execute sql task. I want to update one of the column in my table when anyone of the task in the control get fails?

Please let me know if anyone have an idea how to do this.



Thanks and Regards





View 3 Replies View Related

What Is &"?&" Means In SQL SERVER DBCC REINDEX('?')

Sep 25, 2007

here is example: DBCC REINDEX('?')

Thanks!

View 2 Replies View Related

When Are Transactions A Bad Idea?

Mar 3, 2004

Lets say I have to insert 60,000 or so records into SQL Server from another data source using the sqlTransaction class.

However if at any point an error should occur I would like to roll back any changes.

Would a transaction be a bad idea when dealing with this many records?

Thanks for any advice.

SA

View 6 Replies View Related

Designing Idea Please

Mar 8, 2007

Dear Friends,I'm a junior DBA,
I've to prepare an online examination.
for this, I've three categories.
a)beginer level
b)intermediate level
c)expert level

again here subjects are 6. like sqlserver,oracle,c#,vb.net,html,javascript.
in these subjects, i've to select these three types of questions.
now how can i design for this requirement? shall i create three tables for beginer, intermediate,expert or shall i create 6 tables and write according that?

am i given correct inputs?

please give me an idea to design

thank you verymuch experts.


Vinod

View 2 Replies View Related

Need Good Idea

Jul 23, 2005

Hi guysWe have a following problem. For security reasons in each table in ourDB we have addition field which is calculated as hash value of allcolumns in particular row.Every time when some field in particular row is changed we create andcall select query from our application to obtain all fields for thisrow and then re-calculate and update the hash value again.Obviously such approach is very ineffective, the alternative is tocreate trigger on update event and then execute stored procedure whichwill re-calculate and update the hash value. The problem with thisapproach is that end user could then change the date in the tables andthen run this store procedure to adjust hash value.We are looking for some solution that could speed up the hash valueupdating without allowing authorized user to do itThanks in advance,Leon

View 6 Replies View Related

An Interesting Idea...

Jun 23, 2007

Having no more experience than reading books online, here is an interesting idea I would like to run by you guys and you can let me know if it is feasible or tell me I need to put the crack pipe down...



We are going to increase the number of disks in our SAN, and I was speaking with the SAN administrator and he mentioned the shuffling of logical drives to match the new space. He said he is going to have to go through quite a few combinations/permutations on figuring out the best configuration for what data goes on the old vs. new to get the optimal space.



Is this something that can be modeled out? I can write something that recursively figures it out, but why not explore fun ideas with tools that may be able to do it?



Thank you in advance,

John Hennesey

View 3 Replies View Related

Need Idea About COLLATE

Sep 12, 2007

I need help regarding what is a collate and where to use.If any examples with INNER JOIN it could be more helpful....

View 13 Replies View Related

Have An Idea But Not The Answer.... :( Needed Help

May 31, 2007

Hi,
I have a table that has the ff:
LastName   varchar(50)
FirstName  varchar(50)
PhotoPath  varchar(50)
Now I want to create a form that can accept the LastName,Firstname and also can upload a picture which in turn the filename of the image will be the value for the PhotoPath field, and eventually displays it using the repeater control.
Your Help/Info. is highly appreciated... 
 
 Jeff
 
 

View 3 Replies View Related

New Idea To Use The EXCEPT Operator To Paging

Oct 6, 2007

 Last night, I have this idea, but can not know if it can have a good performance and efficiency when the @CurrentPage is big.-------------------------------------------------------------------DATABASE:AdventureWorks DECLARE @CurrentPage intDECLARE @PageSize intDECLARE @OrderExpression nvarchar(100)DECLARE @Sql nvarchar(500)SET @CurrentPage = 1SET @PageSize = 10SET @OrderExpression = N' employeeid 'DECLARE @BigTop intDECLARE @SmallTop intSET @BigTop = @CurrentPage * @PageSizeSET @SmallTop = (@CurrentPage -1) * @PageSizeDECLARE @StartTime datetimeSET @StartTime = GETDATE()SET @Sql = N' SELECT TOP (' + CAST(@BigTop AS nvarchar(10)) + ') * FROM humanresources.Employee '+ ' EXCEPT '+ ' SELECT TOP (' + CAST(@SmallTop AS nvarchar(10)) + ') * FROM humanresources.Employee ORDER BY ' + @OrderExpressionEXEC sp_executesql @SqlDECLARE @EndTime datetimeSET @EndTime = GETDATE()SELECT DATEPART(s,@EndTime-@StartTime)SELECT DATEPART(ms,@EndTime-@StartTime)GO-----------------------------------------------------------------

View 6 Replies View Related

Can Anyone Explain To Me Why This Is Not A Good Idea

Jan 28, 2008

I have a complex select statement that is used in several stored procedures. I decided that instead of having x number of T-SQL scripts with the same exact select statement that I would to put this query into a view and then do a select * from View.  Recently an instructor told me that this was a bad idea and that anyone who uses a select * from anything should be fired.  When I asked for his reasoning his response was to say the least abnoxious.  I can understand why a Select * from Table might be a bad idea as the table definition can change, but the chances of a view changing seems much less likely.
Is a view a good idea in this case?  Is the Select * from View really a bad idea?
 Thanks
 
 

View 6 Replies View Related

Idea On Hardware Purchase

Oct 29, 2004

I am looking for a good reference on hardware specs for a dedicated SQL server. I don't want to talk to vendors, because I'm not looking to get snowed. Does anyone know of any resources? The server is to be a dedicated dataserver, for about 300 clients.

View 9 Replies View Related

AUTO_UPDATE_STATISTICS A Good Idea?

May 20, 2003

Can anyone tell me if turning on the AUTO_UPDATE_STATISTICS option will have any adverse effects on performance? I've read that it is possible for it to adversely affect performance, because SQL Server “takes a quick break to update database statistics in the middle of the day”. The book does not explain why and I'm always leery of simply accepting something, simply because I’ve read it from a book. This is the first time that I’ve ever heard this and cannot find anything from SQL BOL or any other source.

View 2 Replies View Related

No Idea About MSSQL2000. How Do I Export???

Nov 16, 2006

Hi.. Never used MSSQL 2000 db. I have this website that uses mssql2000. I want to export it and convert db in mysql. Please help me understand how i can do that. I have all login info..

View 1 Replies View Related

Any Idea Of This Replication Error?

Aug 3, 2004

Hi, all..
One database called POS in a server A is replicated with another server B with merge replication.

Server A is distributor and publisher.
I tried to replicate POS db it keeps giving me error following.

"SQL Server Enterprise Manager could not retrieve information about database 'POS'
Error 21776: [SQL-DMO] The name 'POS was not found in the ReplicationDatabase collection. If the name is a qualified name.
user [] to separate various parts of the name, and try again."

When other try it gives following error..
SQL Server Enterprise Manager could not enable database 'POS' for merge replication.
Error 20736: [SQL-DMO] This object has been dropped from the server.

I did all I can do..
I reinstalled sql server and tried again.. but it gives same error..

Does anyone has any idea of this problem????

Please post any idea.

Thank you...

View 3 Replies View Related

Database Design Idea

May 23, 2007

Good morning
In messages system i have table to store messages and another table to contain the links which the message is posted through
Now i want to delete a link but i don't want to delete the message sent through this link
The problem:
When displaying the message sent what will be found in the link field (i.e. for the deleted link)

If any one has a good idea for doing that please reply to me
I don’t want the sql code
I want just the idea
Thanks

kind regards
mohammed Al Maghraby

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved