Forum Replies Created
Viewing 15 posts - 5,266 through 5,280 (of 5,356 total)
-
RE: Need help in creating dynamic fields
Hi Jeremy,
I just wanted to make aware of some pitfalls of dynamic SQL, because simply answer a question to use dynamic SQL implicates considerations on the aspects you've mentioned (eg....
-
RE: Need help in creating dynamic fields
Hi,
once again a topic on dynamic sql. For the pros and cons of this approach take a look at http://www.algonet.se/~sommar/dynamic_sql.html
Cheers,
Frank
-
RE: MSDE 2000
Hi,
the following is taken from BOL (see sp_password)
sp_password [ [ @old = ] 'old_password' , ]
{ [ @new =] 'new_password' }
...
-
RE: enterprise manager
Hi,
I think you buy the server with a limited number of clients licenses. The tool to administrate the Server is not limited to a number of installations.
Well, that's what...
-
RE: Enterprise Manager Security
Thanks Brian,
very sophisticated indeed, but understood. Now I know where to dig deeper on our network.
Cheers,
Frank
-
RE: Other databases
quote:
MySQL has its fans though personally I suspect the MySQL vs other open source databases is the VHS vs Betamax thing again. -
RE: Enterprise Manager Security
quote:
Simply being an admin on one's own box doesn't confer you any additional rights on a separate SQL Server box. -
RE: Enterprise Manager Security
quote:
If it's a production server, developers shouldn't typically have such rights. This will typically be one of the first things flagged in...
-
RE: Other databases
quote:
look at MySQL but have never made the time. Like someone else mentioned, I've used Access to front end other databases,... -
RE: Enterprise Manager Security
quote:
I don't think encrypting the stored procedures will solve your problem. It sounds like too many people have too many rights into... -
RE: Add logins to a database using script.
Hi,
I think not to all objects at once in EM, unfortunately. Maybe per script?
That's the reason for a role. You define the permissions just once for the role. And by...
-
RE: how 2 insert image in a table
Here we go
This one retrieves binary data and writes to file
Dim strStream As ADODB.Stream
sql = "SELECT * FROM mails_attachments WHERE id=" & CLng(DataList3.BoundText)
Set rs = New ADODB.Recordset
cnnArchive.Open SNIPPET_STRING
rs.Open...
-
RE: how 2 insert image in a table
Hi,
if you're doing this with ADO take a look at the ADO Stream Object. A code snippet follows when I find it. Should soon be the case
-
RE: Add logins to a database using script.
Hi,
adding a role is always a good idea. It saves you a lot of time for maintenance.
Cheers,
Frank
Edited by - a5xo3z1 on 05/15/2003 06:05:28 AM
-
RE: Other databases
Hi Stuart,
as I wrote before. It depends on your needs. If you are running a private homepage on the web, you rarely do more than a SELECT * from .......
Viewing 15 posts - 5,266 through 5,280 (of 5,356 total)