Johan Bijnens

Forum Replies Created

Viewing 15 posts - 6,466 through 6,480 (of 7,499 total)

RE: User Problem

Check Information Schema Views in books online.
They are SQL-92 standard.
These views are preferable over the system-tables like sysobjects, sysusers, ... because they follow the standard.
Propriatary systemcatalogtables may change with each fix/servicepack/version.
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

October 31, 2005 at 6:21 am

#601269
RE: Group first, then join?

I'ts always a nice adventure to predict an execution plan yourself and then compare it to the one sqlserver uses
You'll learn a lot...
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

October 31, 2005 at 5:37 am

#601260
RE: User Problem

Well, for sqlserver < ss2005 "specific_schema" = "owner"
If you don't want to filter based on owner, just comment the where clause.
you can run...
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

October 31, 2005 at 4:17 am

#601250
RE: Cannot connect to user default database

Are u allowed to use regedit ?
check [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\yourdsn
and remove the "Database"="faultydbname"
or replace it with a correct dbname
or remove the full...
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

October 31, 2005 at 3:54 am

#601247
RE: User Problem

how about :
-- grant select, insert, update, delete
DECLARE @SQLStatement nvarchar(4000)
DECLARE csrGrants CURSOR LOCAL FAST_FORWARD READ_ONLY FOR
Select 'Grant select, insert, update, delete on [' + [TABLE_SCHEMA] + '].[' + [TABLE_NAME] +...
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

October 31, 2005 at 3:46 am

#601246
RE: Cannot connect to user default database

can you remove the odbc-dsn and then build it up again ?
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

October 31, 2005 at 2:55 am

#601237
RE: Group first, then join?

Offcourse you'll have to check execution plans, but the optimizor will see trough it (I hope)
This would result in a query like this...
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

October 31, 2005 at 2:44 am

#601235
RE: SQL Scripting

Nope

- take a look at SQLDMO
- maybe this can help you out ...
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=107508
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q220/1/63.asp&NoWebContent=1

"C:\Program Files\Microsoft SQL Server\MSSQL\Upgrade\scptxfr.exe" /s yourserver /d...
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

October 28, 2005 at 4:09 am

#600841
RE: Cannot connect to user default database

did someone drop and recreate the database ?
Connect using Query Analyser. You'll also get the message, but it will connect to master and you can work from there on.
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

October 28, 2005 at 3:54 am

#600838
RE: trigger question!

There must be a reason they put the trigger overthere !
If you're not sure, don't disable it !
Johan

Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me

October 28, 2005 at 2:15 am

#600826