Use dbo for questions related to SQL Server database ownership of tables, catalogs, schema, or other database objects
References
Questions tagged [dbo]
70 questions
0
votes
0 answers
PHP DBO - mssql - bigint as join in query
I have a PHP based site that needs to pull some data from a mssql server hosted within the intranet in my office. I have written the sql to pull this data out and logically it works perfectly. During testing on the windows machine, my code returns…
Mike
- 511
- 3
- 10
- 28
0
votes
1 answer
Should I let EF CF create my tables with the user "dbo"?
I am just starting out with SQL Server and I let Entity Framework code first create my data tables. Here's the SQL for one of the tables:
CREATE TABLE [dbo].[UserProfile] (
[UserId] INT IDENTITY (1, 1) NOT NULL,
[UserName]…
user1464139
0
votes
1 answer
cakephp with oracle: no group by?
Greetings,
I'm trying to use the 'group' parameter for a find using CakePHP.
The dbms is oracle and to my surprise it didn't work (no group by in the query).
Example:
$this->User->find('all', array('group' => 'id'));
The query returned:
select *…
Andreas Wong
- 59,630
- 19
- 106
- 123
0
votes
3 answers
Update drop down from SQL database using PHP
I know this should be simple but I just can't seem to get my head around it.
I have a list of continents in a sql database that I get back using PHP DBO and display in a drop down list. What I then want to do is get the users preferred continent…
James
- 474
- 4
- 9
- 22
0
votes
0 answers
Tips on a Stored procedure with CONVERT , Split functions
I'm studying a stored procedure with the following variable that I need to decipher, ResponseRange :
**@ResponseRange VARCHAR(64) = null,**
then later we have:
IF (@ResponseRange is not null)
BEGIN
INSERT
INTO #tempLK_ResponseStatuses
…
Caffeinated
- 11,982
- 40
- 122
- 216
-1
votes
2 answers
Prevent User Usage of "dbo" in User Databases SQL Server
I am attempting to prevent usage of the default schema of "dbo" in my SQL Server databases. This is being applied to an existing long term project with ongoing maintenance where the developers also manage the SQL Server (are all sysadmin).
This is…
DarrenMB
- 2,342
- 1
- 21
- 26
-1
votes
1 answer
T-SQL to change owner to current user if database has no owner
Just wondering if there is some T-SQL that will allow me to assign a user as the owner of a SQL Server database if it doesn't already have an owner?
We're getting the following error out in customer setups:
Cannot execute as the database principal…
Matt
- 3,305
- 11
- 54
- 98
-1
votes
2 answers
Split delimited string in one column and keep other column intact
My table data is as follows
x------x--------------------x
| Key | Ids |
x------x--------------------x
| 1 | 23,34,45,56,78 |
| 2 | 56,76,45,7,98 |
x------x--------------------x
I would like the output to be…
Nisha
- 1,379
- 16
- 28
-1
votes
1 answer
SP Grant Execute
I have a new role, which should have permission to execute list of SP and select some Views.
I run grant execute/select to role on
laggerok19
- 426
- 8
- 16
-3
votes
1 answer
How to track when a data download from SQL Server DB in Email
I am using SQL server email client.
I am sending mails using
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'Mailer_Profile',
@recipients = @Email,
…
Surajit Biswas
- 779
- 7
- 25