Tag Info

Hot answers tagged

8

To answer the specific question of running a SQL Agent job on multiple servers (definitely a good question) and, for the moment, ignoring the particular thing that you want the job to do (which could be another question): SQL Server / SQL Server Agent actually comes with a facility that makes this type of thing very easy: multiserver administration. You set ...


1

I would draw a text backup and search it with vim or any tool of your choice. As far as plpgsql functions are concerned (there is one behind every trigger), you can query the system catalog pg_proc: SELECT * FROM pg_catalog.pg_proc WHERE prosrc ILIKE '%dblink%';


1

Missing "t" on the keyword INSERT "inser into anggota (nama,password) values ('Nabil','1234')"


1

You have a memory problem, something very typical in a memory-bound system, and that can be confirmed on the line: 150207 17:31:42 InnoDB: Fatal error: cannot allocate memory for the buffer pool As InnoDB cannot allocate memory for its buffer pool, it fails, and MySQL cannot start if the InnoDB engine fails (MySQL 5.5). Nothing on your my.cnf seems out ...


1

Whether you use one table or two, you should be able to insert all the data needed for in a single transaction. More importantly, you should not store the password, but instead store a password hash. Here is one post on using a password hash such as SQL Server itself uses. This is using SHA_512 hashing with a 32-bit salt. ...



Only top voted, non community-wiki answers of a minimum length are eligible