Use dbo for questions related to SQL Server database ownership of tables, catalogs, schema, or other database objects
References
Questions tagged [dbo]
70 questions
22
votes
3 answers
Is there a way to use a function on a Microsoft SQL Server Query without using "dbo." before the function?
Is there a way to call a User defined function without using "dbo." before the function name and parameters?
Using:
SELECT USERFUNCTION(PARAM1, PARAM2, PARAM3, PARAMN)
instead of:
SELECT dbo.USERFUNCTION(PARAM1, PARAM2, PARAM3, PARAMN)
alexzm1
- 563
- 2
- 7
- 14
9
votes
3 answers
How to connect to Sybase via PHP
I'm trying to connect to a Sybase database with PHP5. I believe I've successfully compiled PHP with PDO_DBLIB, as phpinfo() lists dblib under PDO drivers, and freetds as the pdo_dblib flavour.
However, when I try to test a connection, I get an…
zwiebelspaetzle
- 250
- 1
- 3
- 8
5
votes
5 answers
dbo in SqlServer
I'm converting database from Teradata to SqlServer. I've noticed all tables and procedures are named by the prefix "dbo." (e.g. "dbo.Table1").
I would like to know if and how I can get rid of "dbo" because it would make the conversion task a lot…
ala
- 7,070
- 13
- 47
- 54
5
votes
3 answers
How to find the details of a DBO change on a database?
I would like to run a query to view when and by whom the DBO of a particular database was changed. How would I do that?
user1683507
- 51
- 1
4
votes
5 answers
lu.[TableName] instead of dbo.[TableName]?
Some of the tables in my SQL Server 2005 database is named as lu.[TableName] instead of dbo.[TableName]. What does lu stand for?
Note: I tried google already
burnt1ce
- 14,387
- 33
- 102
- 162
3
votes
1 answer
SQL Alias vs dbo.prefix - query performance
Assuming you're using MS SQL Server:
Which of these queries will execute the fastest, and WHY?
I'm going to guess the last, as I'm thinking that Aliases are only resolved to their tables once?
SELECT Account.AccountName,
…
jimasp
- 962
- 9
- 26
3
votes
1 answer
How to check if I'm currently the database owner for SQL 2000/2005/2008
I can't remember how to do this in a TSQL query. It was a one-liner, good for testing before running DML. The query was something similar to SELECT IS_DBO() or SELECT IS(DBO).
scottwed
- 187
- 2
- 12
2
votes
3 answers
DBO rights risk
I'm advising a friend who manages a SQL 2k5 box that has several users who have dbo access to multiple databases. The problem is:
These users haven't had their passwords changed for some months,
These users put their IDs into applications and the…
Caveatrob
- 12,667
- 32
- 107
- 187
2
votes
0 answers
const std::string argument propagation failure in constructor
I am learning to use the Wt (witty) C++ Library, and tried to improvise on the Dbo::Session with singleton. The following is a snippet from the MySQL Backend Singleton wrapper that I had created.
Failure Case
The program compiles and runs with an…
hell_ical_vortex
- 361
- 2
- 11
2
votes
1 answer
Assign role of db_denydatawriter to user dbo
When I try to do this I receive the following error message:
Add member failed for DatabaseRole 'db_denydatawriter'. (Microsoft.SqlServer.Smo)
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. …
mwolfe02
- 23,787
- 9
- 91
- 161
2
votes
1 answer
Access joomla's helpers from outside php file
I'm trying to access joomla's methods from a php file on the same server.
$shop_directory = '/var/www/components/com_shop';
$base_directory = '/var/www';
define( '_JEXEC', 1 );
define( 'JPATH_BASE', $base_directory);
define( 'JPATH_COMPONENT',…
Mazeltov
- 541
- 5
- 18
2
votes
1 answer
running query against two DB tables between linked servers causing collation error
Cannot resolve the collation conflict between
"SQL_Icelandic_Pref_CP1_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in
the equal to operation.
I am trying to check for duplicates between two tables and created a linked server and then created the…
vbNewbie
- 3,291
- 15
- 71
- 155
1
vote
1 answer
SQL Server Express 2008 database User dbo with blank Login
We have SQL Server Express 2008 on a production server. For the database in question we need to ensure that the local development version is identically configured to that on the production server.
In the production db the User dbo has a blank…
Serexx
- 1,232
- 1
- 15
- 32
1
vote
1 answer
How to find location in database of CPU intensive query?
I have a server called "Reporting" and looking at SQL Server performance reports, specifically "Top Queries by Total CPU Time". I have found the top CPU Time consuming queries.
The number 1 query shows me the "Query Text", "Database Name", "Object…
Will
- 103
- 6
1
vote
1 answer
Cannot find the principal 'dbo', because it does not exist or you do not have permission
This question is focussed on why this has happened.
We restored a database from another server that has failed. The restore succeeded, but when we try and run any stored procedure (using 'sa' login, or Windows-based login with full admin access),…
EvilDr
- 8,943
- 14
- 73
- 133