Viewing 15 posts - 256 through 270 (of 270 total)
This post was just trying to find out the best way to use each of the three objects in different situations, if you have good advice on how to use...
February 6, 2005 at 11:04 pm
I searched "Ownership Chains" on BOL...it helped a lot !
February 4, 2005 at 12:32 pm
For more info I searched "Ownership Chains" in SQL BOL.
February 4, 2005 at 12:29 pm
No reason to follow same logic, but I am going to have to learn SQL server best practise.
Whats the code for changing temdb size to handle more data ?
February 4, 2005 at 10:07 am
Thanks for help David...Top man !
Is there any example code on re setting TempDB on matters of size ?
February 3, 2005 at 9:07 pm
Excellent response thanks, A few Questions
.."If your first few steps only take a few seconds then I would use temporary tables or table variables and have a stored procedure...
February 2, 2005 at 4:28 pm
I think I am sorted out now.
When doing read only query of a #temp table with a join to dbo.table, the different owners of the object does not matter.
This is not...
February 1, 2005 at 7:41 pm
what is the correct technique to do joins between tables when the tables Or objects have been created by different owners.
the owner dbo is from sysadmin role, a user(client) owner...
February 1, 2005 at 10:38 am
Concerning... this code..
SELECT a.i, a.j
FROM tempdb.dbo.#Table1 a
INNER JOIN
northwind.dbo.Table2 b
ON a.i = b.i
GO
What if "tempdb.dbo.#Table1" was going to be created by any user, like....
January 31, 2005 at 6:37 pm
I think I can answer my own question...
I found this on BOL...
Second paragraph.. makes the point..
The dbo is a user that has implied permissions to perform all activities...
January 31, 2005 at 6:29 pm
I dont think TSQL has windows API functions like Vb6.0, you may have to build TSQL and load info from client interface ( vb/Access).
Exporting by script from SQL table
http://vyaskn.tripod.com/programming_faq.htm
January 31, 2005 at 11:15 am
Thanks for help..
My concern.."How does SQL 2000 handle multi user when, two clients at the exact same time run the TSQL code for two different customers ?"..
Say client1 WHERE clause...
January 30, 2005 at 4:13 pm
I will use TSQL, thats my question.
Say I have a TSQL code that creates a table and populates it with data for a @Customer and then I send the data for report via...
January 30, 2005 at 1:39 pm
Can somebody also explain how the SQL server with mutli user activity how the database works with objects( tables, procedures, etc)
Does it create a mirror set of permanent objects for each...
January 30, 2005 at 12:24 pm
I tried that but, it did not work
ALTER TABLE dbo.Authors NOCHECK CONSTRAINT ALL
Batch ran ok, then I attempted to DROP table, that got the above error message, any ideas
December 4, 2004 at 3:59 pm
Viewing 15 posts - 256 through 270 (of 270 total)