| Author |
Topic |
|
ahmeds08
Aged Yak Warrior
737 Posts |
 Posted - 2010-11-24 : 04:16:18
|
| hello evrybody,could anybody help me out of this.why do i get the error 'invalid object name dbo.dtproperties'does this table exist in the systables or do i need to create it.thanx in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-11-24 : 09:26:58
|
| dtproperties is table which will created only when you create database diagram. Can I ask where you're using it?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2010-11-24 : 11:14:36
|
| i have a stored proc where iam using it to retrieve views which i have created with encryption.when i exec the proc i get a error message invalid object name dtproperties |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-24 : 11:25:44
|
| Don't know if it's been fixed but this used to be created as a user table rather than a system table and had to be specifically excluded in scripts. Don't know why you should be looking at it for views though.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2010-11-24 : 11:35:42
|
| see..the general query for selecting a views is 'select * from syscomments'.but when you create a view with encryption you cannot see it with the above query.but when you want to get the encrypted views you have select from the dtproperties table. |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2010-11-24 : 11:37:54
|
| see..the general query for selecting a views is 'select * from syscomments'.but when you create a view with encryption you cannot see it with the above query.but when you want to get the encrypted views you have select from the dtproperties table. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2010-11-24 : 11:46:02
|
| im not trying to hack any thing boss.i have listened a class on this.so iam taking a chance.nothing else.and by the way iam the owner of the database. |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-24 : 11:47:32
|
quote:
Originally posted by ahmeds08
see..the general query for selecting a views is 'select * from syscomments'.but when you create a view with encryption you cannot see it with the above query.but when you want to get the encrypted views you have select from the dtproperties table.
Really?That would imply that when you create an encrypted view that dtproperties is created and the text stored there.Wonder how it is differentiated from a diagram.I think they will still be named in information_schema.views==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2010-11-24 : 11:55:33
|
| ok..leave the topic.but can u tell me do we use this type of techniques for decrypting views.or did any time u have faced such a requirement.iam asking you people bcoz u have good hands on experience.and iam a new bee to sql.and thanx for all your replies. |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-24 : 12:02:15
|
| Wouldn't try it.If a someone uses encryption for text then they should realise the consequences and plan for it.A database isn't a good place to secure these sort of objects anyway so theoretically it shouldn't make any difference - only for detecting changes that have been made to the system.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
dtproperties