Topic profile page for Dbo.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Dbo.
Topic "Dbo" was discussed 8,940 times on 400 sites in last 3 months
Started 4 days, 16 hours ago (2009-12-03 05:25:00)
by markroworth
Hi there, I am trying to understand under what circumstances there would be in using a different table owner other than dbo. My DBA has (it seems arbitrariry) to use different table owners with no real benefit other than it makes. The only effect of it seems to make for longer, harder to read code. Can anyone give me a brief rundown for common design reasons for it. Thanks, Mark
Started 6 days, 5 hours ago (2009-12-01 17:18:00)
by NicoleVT2000
I have a custom Java application that is using a MS SQL Server 2005 database as a datasource. We are using a JDBC connection. When the database was initially setup the default schema was kept at dbo. When using the dbo schema our connection works fine and the application runs as expected. We now have a need to change the default schema to something other than dbo. When we made the change to...
Started 1 week, 4 days ago (2009-11-26 16:16:00)
by Dave0323
All, The stored procedure [dbo].[NSAdministrationHistory] in ..NSMain db for sql server notification doesn't return a correct NotificationSuccessfulDeliveredCount. I think the problem is from a "AND DeliveryStatusCode = 0" filter. Does anyone know when MS will fix this problem. Here is a query statement from the sp above. ...
Started 1 week, 5 days ago (2009-11-25 13:45:00)
by Myrkr
Hi. I'm pretty good with Access, but not so much working with ADP. I have a SQL Server 2005 back end linked to an Access 2003 adp. All's well, except as of yesterday, the table list and the Queries in the ADP started showing (dbo) behind each entry. This wasn't the case yesterday morning. When selecting a record source, ...
Started 1 week, 6 days ago (2009-11-24 16:14:00)
by TJ_1
Hello room, I just completed the transactional when changes made in the publisher data. The Distribution agent failed with the following errors: Could not find stored procedure 'sp_MSins_dbo_Table_Name' Command attempted: if @@trancount > 0 rollback tran (Transaction sequence number: 0x0000CC7100003911000100000000, Command ID: 3) Error messages: Could not find ...
Started 1 week, 6 days ago (2009-11-24 09:53:00)
by wwestendorp
Hi, If a user go's to the Sales Module, Sales Order he receives a message that his user account and /or passord is not okay. If we give him just DBO rights on the Database it works. We have a view which will be checked(data) when opening that Form. Why does the user needs DBO rights or how can we modify this so the users have Normal SQL Rights? Regards, William
Started 2 weeks, 3 days ago (2009-11-20 16:34:00)
by ASPRonin
I am creating a stored procedure that will loop through a table and email people with card that are overdue. when I try to compile the code i get the error "The multi-part identifier "dbo.CardIssue.DueDate" could not be bound.". Below is my procedure and below that is the error that i'm getting. i'm running on SQL 2005. Any help would be greatly appreciated. Thank you in advance. CREATE...
Started 2 weeks, 5 days ago (2009-11-18 19:20:00)
by jijerald
Hi, I am trying to use sp_send_dbmail to send a custom email. I am essentially using this for sending some custom alerts. When I execute the following it works fine. I get the 'mail queued' message and I recieve the mail in mail account. EXEC msdb . dbo . sp_send_dbmail @recipients = 'jithin.jerald@xyz.com' , @subject = 'Trial' , @Body = 'Blank ...
Started 3 weeks, 3 days ago (2009-11-13 07:55:00)
by Promise
Hi Friends, I have created a function and am trying to call it but i get an error that says Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fn_ClientContract_FindRootNode_ExcludeRootNot eWithNoChild", or the name is ambiguous. can you please look at my SQL tatement and correct me. your help is hignly appreciated. CREATE FUNCTION [dbo].[fn_...
Started 3 weeks, 5 days ago (2009-11-11 16:46:00)
by Ranga1
I need to grant drop and create permissions for my developers on all stored procs owned by dbo, SQL 2005 SP3 For example: if exists (select * from sysobjects where id = object_id(N'[dbo].[TempSP]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[TempSP] GO Create Proc dbo.TempSP AS Select 1 What is the least permissions I can grant other than Grant control on dbo ...
Started 5 days, 5 hours ago (2009-12-02 16:37:00)
by YoMismo2009
Hi, I have the following problem... when I execute this: DECLARE @return_value int EXEC @return_value = [dbo].[spUSR_BuscarUsuario_00] @XmlInfo = N '' SELECT 'Return Value' = @return_value I receive this message: Msg 105, Level 15, State 1, Line 2 Unclosed quotation mark before the character string ...
Started 1 week, 1 day ago (2009-11-29 20:29:00)
by Lasha34
Hello how can i save this converted time If m_DataSet.HasChanges() Then Dim data_adapter As SqlDataAdapter Dim Command_Builder As SqlCommandBuilder Conn = New SqlConnection(ConnectionString) strSQL = "SELECT id,comment,CONVERT(varchar(35), tb1.Time1, 108) As Time1,description FROM dbo.tb1"...
Started 1 week ago (2009-11-30 13:46:09)
by persistentDeveloper
Hi Using a stored procedure to carry out search. All working fine. Now i have a ListBox where more than one ListItem can be selected. Using a StringSplit function and its working fine. (@Country IS NULL or country COLLATE DATABASE_DEFAULT IN(Select Items from dbo.StringSplit(@Country,','))) In database table country column may have 'UK USA Italy' etc. In order to implement ...
Started 1 week, 1 day ago (2009-11-29 19:39:00)
by newbie2C#
I'm using a SqlDataSource for a details view that uses stored procedures for the update and delete capabilities. I noticed in the SSMS that my stored procedures had schema info as a prefix on the objects. This was like this: dbo.spMyStoredProcedure. My details views delete and update capabilities work with out doing this, but I'm wondering if my app would perform better with this schema info ...
Started 1 week ago (2009-11-30 15:50:22)
by jballhrb
How can this be converted from Microsoft EnterpriseLibrary to ADO.NET? Public Function SelectByWeekNum(ByVal weekNum As Integer) As DataTable Try Dim db As Database = DatabaseFactory.CreateDatabase("LocalSQLServer") Dim dbCommand As DbCommand = db.GetStoredProcCommand("dbo.[pr_vw_aspnet_GetHour sByWeek]") db.AddInParameter(dbCommand, "@...
Started 4 days, 13 hours ago (2009-12-03 08:47:26)
by kingchemical
i have this query and i want to convert it to linq SELECT DISTINCT dbo.ExemptionDetails.CustomerID, dbo.Customer.CustomerName, dbo.ExemptionItems.ExemptionID FROM dbo.ExemptionDetails INNER JOIN dbo.ExemptionItems ON dbo.ExemptionDetails.ExemptionItemID = dbo.ExemptionItems.ExemptionItemID INNER JOIN dbo....
Started 4 days, 23 hours ago (2009-12-02 23:08:49)
by liju.thn
hi , I have a problem with a table valued function which i used to split the string using a delimitter, "," The function is as follows set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER FUNCTION [dbo].[testfn] ( @StringToSplit VARCHAR(500), @Delimiter CHAR(1) ) RETURNS @SplitTable Table ( DataValue VARCHAR(50), ValueAt Numeric(9,0) IDENTITY(1,1) ) AS ...
Started 1 week, 1 day ago (2009-11-29 11:23:00)
by dbo
DBO’s World Rankings at BHO: November 2009 Heavyweight BHO Champion: Wladimir Klitschko UKR 1.) Vitali Klitschko UKR 2.) Alexander Povetkin RUS 3.) Eddie Chambers USA 4.) Ruslan Chagaev UZB 5.) David Haye UK 6.) Nicolay Valuev RUS 7.) John Ruiz USA 8.) Cristobal Arreola USA 9.) Denis Boytsov RUS 10.) Tony Thompson USA Movement: Haye jumps from ninth to fifth off of his narrow win over ...
Started 1 week ago (2009-11-30 09:34:00)
by 99Chuck99
New to SQL server and was wondering if the following snipit of code can be done. I would like to name the column in the query to the month with the AS statement. Thanks in advance. SUM(CASE WHEN datepart(MONTH, (DATEADD(M, - 1, GETDATE())))= DATEPART(MONTH, dbo.ACTION.ACTION_DATE) THEN 1 ELSE 0 END) AS datepart(MONTH,(DATEADD(M, - 1, GETDATE()))) ,
Started 6 days, 15 hours ago (2009-12-01 06:32:00)
by griffitd
Hi I have the following SQL which give me a Incorrect syntax near the keyword 'SELECT'. Can someone help. Thanks SHAPE {SELECT sd.ShippingDeliveryID AS [ID], sd.CarrierReference AS [Carrier Ref], sd.OriginCode, f.OriginDesc as [Origin], sd.DeliveryLocationCode, dbo.ConvertDateToyyMMMddDDD(sd.DeliveredDateTime) AS [Delivered Date], sd.DeliveredDateTime AS DeliveredDateTimeUnformatted ...
